How to insert missed @ or .(dot) in an email address

nasimul · Post by **nasimul** » Mon Jun 02, 2008 12:14 am

Hi,
I need to insert @ and/or . (DOT) symbol if email addres doesn't contain that.

For example:

1. xyz@gmailcom should be changed to xyz@gmail.com (here missing dot is inserted)

2. xyzgmailcom should be changed to xyz@gmail.com (here missing dot and @ is inserted)

3. xyzgmail.com should be changed to xyz@gmail.com (here missing @ symbol is inserted)

Please let me know how can I achieve this through QualityStage/DataStage?

Regards,
Nasimul

ray.wurlod · Post by **ray.wurlod** » Mon Jun 02, 2008 1:00 am

QualityStage match against list of valid domains. Survive matches from the valid list.

nasimul · Post by **nasimul** » Mon Jun 02, 2008 1:06 am

Thanks.
Please let me know which rule set matches against list of valid domain so that I can use it.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 02, 2008 1:13 am

Customized VEMAIL, as noted in your other thread.