Zahvaljujem. Au, pa izgleda da bas skoro sve prolazi. Nesto smo ipak naucili iz cele price, REGEX ili ne REGEX
Izgleda da postoje dva oblika:
<neki text>@[IP adresa]
<neki text>@example.<neki text>.com
Znaci, ako minimum, treba nam @ I neki text ispred toga (bukvalno bilo sta?)
Posle @ dodje ili IP adresa u zagradama []
ili imamao @.nesto. neki text.com - bar jena tacka iza @ i dva ili tri karaktera iz atacke .rs, .org mozad i .a samo?
Vazi li i dalje da ne smeju da budu zajedno dva znaka @, kao @@ ?
Testirao sam moje ogranicenje u Accesu, sa ovim cudno izgledajucim primerima:
Code:
Left([Email],1) Not In ("@",".")
And Len([Email])>=6
And Right([Email],1) Not In ("@",".")
And (Len(RTrim(LTrim([email])))=Len([email]))
And InStr([email],".")>0
And InStr([email],".@")=0
And InStr([email],"@.")=0
And InStrRev([email],".")>InStrRev([email],"@")
And (Len([email])-InStrRev([email],"."))>=2
And (Len([email])-InStrRev([email],"."))<=3
ZNacenje ogranicenja:
Left([Email],1) Not In ("@",".") -- no > or @ at the beginning
And Len([Email])>=6 -- at least 6 characters
And Right([Email],1) Not In ("@",".") -- does not end with @ or .
And (Len(RTrim(LTrim([email])))=Len([email])) -- no space characters AT THE BEGINNING OR AT THE END
And InStr([email],".")>0 -- there must be at least one .
And InStr([email],".@")=0 -- no . and @ next to each other, AS IN .@
And InStr([email],"@.")=0 -- no > and @ next to each other, AS IN .@
And InStrRev([email],".")>InStrRev([email],"@") -- at least one . must be after @
And (Len([email])-InStrRev([email],"."))>=2 -- at least 2 chars after last .
And (Len([email])=Len(Replace([email]," ",""))) -- no spaces in the middle -- ovo je uklonjeno da bi prosao "much.more unusual"@example.com
And (Len([email])-InStrRev([email],"."))<=3 -- no more than 3 chars after last .
Evo sta je sve proslo:
Email
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
"""much.more unusual""@example.com"
!#$%&'*+-/=?^_`{}|
[email protected]
"""()<>[]:,;@\\\""!#$%&'*+-/=?^_`{}| ~.a""@example.org"
""" ""@example.org"
Sta nije proslo:
"
[email protected]"@example.com -- no go, ima dva znaka @
user@[IPv6:2001:db8:1ff::a0b:dbd0] -- no go, nema znak . posle @
admin@mailserver1 -- no go, nema . polse @
Ko hoce, moze da proba da napise REGEX ili ogranicenje koje prihvata ovo sto moj uslov odbacuje.
[Ovu poruku je menjao Zidar dana 05.07.2013. u 18:05 GMT+1]