REG_MATCH - String contains or like operation in Informatica

To check if a substring is present in a string like '%%' is used in SQL. Equivalent regular expression will be

REG_MATCH(Company,'.*le.*)

CompanyResult
BentleyTRUE
beach valleyTRUE
HPFALSE
AdobeFALSE


Test Try the above example