E-mail edit

[Richard Kreiss]

> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of scooter6 at gmail.com
> Sent: Wednesday, April 04, 2012 10:59 AM
> To: filepro-list at lists.celestial.com
> Subject: E-mail edit
> 
> I'm adding a required field in our client file for a primary email address
> contact....
> Does anyone have an edit in place that will at least validate there is an
"@"
> sign and at least ONE (.)
> i.e.  it would at least validate that     jdoe at filepro.com      IS valid;
> whereas  jdoe at filepro would NOT be valid and neither would  jdoe-
> filepro.com
> 
> Any assistance is appreciated
> thanks
> 
> Scott

You could test with strtok on leaving the field

If:
Then:Aa=strtok(email,"@") 
If: aa lt "1"
Then: MSGBOX "The \r @ \r has been omitted from this email address";SCREEN
,.....


Richard Kreiss
GCC Consulting

Office: 410-653-2813