Match functions to validate email id

[Former Member]

Hello all,

I am trying to validate email id using Match_Pattern , Match_Simple, Match_Regex . What is the best way to use these functions in this scenario ?

abc.def@geh.com

abc123@geh.ch

abc_def@geh.in

Thanks & Regards,

Rajesh

[virginia_hagen]

If you are looking to have those three email address be a "match", you might consider using the logic built into the Match transform.  It uses a similarity score to determine how alike two things are, and can be configured to find them as a duplicate.  there are other things that come into play with the match transform in that you have to get the records together in a logical group, without the group getting too large or excluding once you want to have compared. 

[vnovozhilov]

In case you know regular expressions match_regex() would be the one

There are plenty examples out there on what regex would look like. It would be something like this:

/^[a-z0-9]([a-z0-9.]+[a-z0-9])?\@[a-z0-9.-]+$/

Then, have a look at the match_regex() syntax in chapter 6.3.102 of SAP Data Services Reference Guide [http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_reference_en.pdf] and adjust if required.

Thank you,

Viacheslav.