Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Email Validation
Message
From
04/11/2011 15:34:45
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01454317
Message ID:
01528118
Views:
60
>>>>This is the function I use
>>>>Function ValidEmail
>>>>   Lparameters lcMail
>>>>   Local ox, llReturn
>>>>   If Pcount()>0 And Vartype(lcMail)='C'
>>>>      ox=Createobject('VBScript.RegExp')
>>>>      ox.Pattern= '^[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]' + ;
>>>>         '@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]' + ;
>>>>         '\.[a-zA-Z]{2,4}$'
>>>>      ox.IgnoreCase= .T.
>>>>      ox.Global=.F.
>>>>      llReturn=ox.Test(lcMail)
>>>>      Release ox
>>>>      ox=.Null.
>>>>   Endif
>>>>Return llReturn
>>>>
>>>I tried this and another pattern, and they both reject this e-mail
>>>
>>>FLastname@name-mtn.com
>>>
>>>But I know it's a valid e-mail. What pattern is correct for e-mail validations?
>>
>>
"^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$"
according to Craig Boyd's blog http://www.sweetpotatosoftware.com/spsblog/2006/01/04/ARegularExpressionsLibraryForVisualFoxPro.aspx
>
>I tried the pattern suggested by Sergey in this thread and it works fine and much simpler. However, I haven't tested it too thorough yet - may be that pattern is too generous.

According to what Craig said, the pattern I presented is the "official" version.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform