REG_MATCH - String starts with check in Informatica

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

REG_MATCH(company,'B.*')


.* 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,'(B|b).*')

or
REG_MATCH(company,'[Bb].*')


Visualize the above example