-
Re: Doubt in email Validation....
Robert Svebeck May 14, 2017 3:57 AM (in response to Gulshan Rohilla )if (purgechar(purgechar(Upper(Email),'ABCDEFGHIJKLMNOPQRSTUVXY.-_@')=Upper(Email),'Valid','Not valid') as Email.status
-
Re: Doubt in email Validation....
Robert Svebeck May 14, 2017 3:59 AM (in response to Robert Svebeck)OoopsNot Purgechar. I meant keepchar...
-
-
Re: Doubt in email Validation....
Robert Svebeck May 14, 2017 4:00 AM (in response to Gulshan Rohilla )Here is it... finallyif (keepchar(Upper(Email),'ABCDEFGHIJKLMNOPQRSTUVWXYZ.-_@')=Upper(Email),'Valid','Not valid') as Email.status
-
Re: Doubt in email Validation....
Gulshan Rohilla May 14, 2017 4:55 AM (in response to Robert Svebeck)thanks Robert
Now its working fine... Can you explain me this ('ABCDEFGHIJKLMNOPQRSTUVWXYZ.-_@') section...
-
Re: Doubt in email Validation....
Robert Svebeck May 14, 2017 5:19 AM (in response to Gulshan Rohilla )That is a list of the characters you want to keep from the email adress when comparing to the original content.
Keepchar examples:
keepchar('bonjour','jour') = 'bon'
keepchar('Abcd123','123') = '123'
purgechar is the opposite, it define which characters should be removed :
purgechar('bonjour','jour') = 'jour'
purgechar('Abcd123','123') = 'Abcd'
Have a look in the help files. They have often good examples. As a beginner though it is dificult to know "what" to search for. But if you search for "string functions" in the help, you will find a lot of useful functions.
Robert
-
Re: Doubt in email Validation....
Gulshan Rohilla May 14, 2017 8:00 AM (in response to Robert Svebeck)Thank You Robert again, but i just want to know why you are using hyphen and underscore(-_) in the substring..
-
Re: Doubt in email Validation....
Robert Svebeck May 14, 2017 8:24 AM (in response to Gulshan Rohilla )Oh, ok. Yes I added those because they are valid email characters and might exist, so they are needed for the comparison, in a general pupose. Perhaps they are not valid in your organization, if this is the case, just remove them.
-
Re: Doubt in email Validation....
Gulshan Rohilla May 14, 2017 8:26 AM (in response to Robert Svebeck)ok, Got it
Thanks Robert
-
Re: Doubt in email Validation....
Robert Svebeck May 14, 2017 9:49 AM (in response to Gulshan Rohilla )Great. If you agree on the answers, please close the question as "answered", so the community can focus on unanswered questions.Thanks,
Robert
-
-
-
-
-
-