MATCh_REGEX is not working properly, and sending all records to fail table??/

[former_member187942]

Hi Gurus,

I have used the below string in Validation, but upon running all my emails are directed to fail schema even though it matches pattern as I understand.

Requirement: Email ID: russell_klein@mbctckrg.com

String in Validation:

match_regex(QT_LOOKUP.EMAIL,'^[-a-z A-Z]+[0-9-_%#*a-z A-Z]*(\.[a-zA-Z]+)*[0-9]*@[a-zA-Z]+(\.[a-z A-Z])+$',NULL) = 1

[Saravanan_SD · Accepted solution]

Hi Shiv,

Please refer the below answer.
https://archive.sap.com/discussions/thread/3606298

Regards,
Saravanan