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
REG_MATCH(Employee,'.*Be.*')
Employee Result
Beat TRUE
Bearo TRUE
Kartheek FALSE
Deb FALSE
No comments:
Post a Comment