Skip to Content
0
Aug 21, 2017 at 12:47 PM

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

128 Views Last edit Aug 21, 2017 at 02:25 PM 4 rev

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