REG_MATCH - Check string matches a specified regular expression - Syntax and Usage in Informatica

REG_MATCH compares given string with regular expression and returns true if the match is successful.

REG_MATCH( input_string,regex_pattern )

ArgumentRequired/OptionalDescription
input_stringRInput string which has to be compared
regex_patternRPerl Compatible Regular expression


If you are new to regular expression, read this tutorial Learn Regular Expression Basics

And before you use them in informatica, test them. Don't make any guesses [Reg ex are little weird for new comers'

Test Regular Expression

Example : Validating a phone number
REG_MATCH (Phone_Number, '(\d\d\d-\d\d\d-\d\d\d\d)' )

Phone_Number Return Value
408-555-1212TRUE
NULLNULL
510-555-1212TRUE
92 555 51212FALSE
650-555-1212TRUE
415-555-1212TRUE
831 555 12123FALSE