E-mail validation

[gmdin]

I am trying to validate a e-mail field in the datawindow so that it is in the form of a@b.c
where 'a' has
--characters from a to z and upper case A to Z
--Hypens(-)
--Underscores(_)
--Periods(.)
it should check for @ sign,

'b' should check all of the contents in 'a'

The period after 'b' should be checked

'c' should be no less than two characters and not more than six characters.

Please help

Thanks

 

[varocho]

You'll need to use the Pos() function.

 

[pupochek]

Something along these lines:
( NOT Match(GetText(),~"[^A-Za-z0-9\.@_\-]~&quot OR NOT (Match(GetText(),~"[@+]~&quot AND Match(GetText(),~"[/.+]~&quot)) AND NOT (pos(GetText(), ~".~&quot = 1 OR pos(GetText(), ~".~", Len(GetText())-1) = Len(GetText()) OR pos(GetText(), ~"@~&quot = 1 OR pos(GetText(), ~"@~", Len(GetText())-1) = Len(GetText()) OR Pos(GetText(),~".@~&quot>0 OR Pos(GetText(),~"@.~&quot>0)