How to count # of occurrences of a character inside a string?

LEN(ColumnToCheck) - LEN(REPLACE(ColumnToCheck,"M",""))

Like Operation in expression transformation

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


REG_MATCH(Employee,'.*Be.*')


Employee Result

Beat                 TRUE

Bearo                 TRUE

Kartheek         FALSE

Deb                 FALSE