Skip to Content
author's profile photo Former Member
Former Member

Match functions to validate email id

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 15, 2016 at 05:01 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 15, 2016 at 09:41 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.