REG_MATCH - String ends with check in Informatica

Use the following pattern to check if string starts with specific pattern

REG_MATCH(company,'.*Y')


.* means any character, repeated for any number of times.

CompanyResult
BentleYTRUE
beach valleyFALSE
HPFALSE
AdobeFALSE


Pay a little attention to second result, regular expressions are case specific by default to over come that you can use the following pattern which will match beach valley too.

REG_MATCH(company,'.*(y|Y)')

or
REG_MATCH(company,'.*(y|Y)')


Visualize the above example