Skip to Content
0

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

Aug 21, 2017 at 12:47 PM

55

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Saravanan Sasikala Duraisamy
Aug 22, 2017 at 02:22 AM
0

Hi Shiv,

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

Regards,
Saravanan

Share
10 |10000 characters needed characters left characters exceeded