Re: Email Validation

From: SoulSurvivor <markyg_7_at_yahoo.co.uk>
Date: 8 Apr 2003 06:40:57 -0700
Message-ID: <8d9c6fd.0304080540.ef7ba67_at_posting.google.com>


Yoy can do basic email validation by checking for the presence of a single '_at_' and one or two '.'.

Because this sounds like homework i wont give you a full solution but 'guide you', better for your learning curve! :-)

Many ways of doing this. INSTR to search for the presence of a character in a string. Or combine the LENGTH and REPLACE functions to find out how many '_at_' you have in a string.

Let us know you solution.

M

"Wayne Hinch" <hinchy2000_at_lineone.net> wrote in message news:<b6u3va$ckg$1_at_titan.btinternet.com>...
> I have used forms for about 3 months now i am using it to create a prototype
> system for my final year project at university.
>
> Any more help than this will be much appricated.
>
> Wayne
>
> "Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message
> news:1049788007.32939_at_news.thyssen.com...
> > "Wayne Hinch" wrote...
> > > Hi,
> > >
> > > I am trying to validate an email which a user will enter, how do I go
> about
> > > to do this? I would like to trap for an _at_ and a . in the text field on a
> > > form which is being programmed in Forms 6.0.
> > >
> > > Any help will be much appreciated.
> > >
> > > Wayne
> > >
> > >
> > Hi Wayne,
> >
> > sorry if I'm totally wrong, haven't used Forms for a long time.
> > Can't you use the INSTR function?
> >
> > hth,
> > Guido
> >
> >
Received on Tue Apr 08 2003 - 15:40:57 CEST

Original text of this message