Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

REG_MATCH - String ends with check in Informatica

  1. Forget Code
  2. Informatica
  3. REG_MATCH - String ends with check
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