- PowerCenter 10.5.1
- All Products
String datatype. Passes the value you want to match against the regular expression pattern.
String datatype. Regular expression pattern that you want to match. You must use perl compatible regular expression syntax. Enclose the pattern in single quotes. For more information, see REG_EXTRACT.
REG_MATCH (Phone_Number, '(\d\d\d-\d\d\d-\d\d\d\d)' )