Validate email ID

[RAJARP]

Hi all,
In my parallel job, i need to validate email ids coming from source.What are all the things do i need to check whether the email id is valid? i am having
1.checking for the presence of symbol @ and
2.checking for spaces in the id, if any
in my mind.I am thinking of doing all these validations in a transformer stage.kindly suggest.

Example data:
No ID
1 raja@yahoo.com----->this is an valid id
2 ramyahoo-------------> this is an invalid id

Thanks & Regards,
Raja R P

[anbu]

Use Index function to search for @ and space

[ray.wurlod]

If you have QualityStage licensed you can use the VEMAIL rule set.

[chulett]

There's a heck of a lot more to it than that, but Index would give you a minimal check. All kinds of regexp samples posted on the 'net for stuff like this - email, phone number, etc which a search should turn up. May help... may not.

[agpt]

you can check few other things also for example:
1) there is only one and only one @ symbol available in email id
2) no occurrence of two consecutive periods i.e. (..)

[antonyraj.deva]

you can check few other things also for example:
1) there is only one and only one @ symbol available in email id
2) no occurrence of two consecutive periods i.e. (..)

You can add an indexed lookup for the known Mail service providers to the above two checks for better results.

Thanks,
Tony

[priyadarshikunal]

viewtopic.php?t=132811&highlight=

use the code in this post by DSGuru2B to start. you can put the dynamic array in stage variable. Create the varaibles used in the routine as stage variables and then do the checks in another stage variable.

also you can use index function to locate mail extention, but instead of searching for '.ed' search for ',.ed,' with leading and trailing delimiter, you should add leading and trailing delimiter in dynamic array too.

[RAJARP]

Hi,
Thanks for all.I have used parts of DSGuru2B's code and validated Email ids.

Regards,
Raja R P