...
The SIMILARTO function returns ‘true’ if its pattern matches the given string otherwise returns ‘false’. It is similar to the ‘LIKE’ function, except that it interprets the pattern using the SQL standard's definition of a regular expression.
Example
SIMILARTO('xyz';#testcsv!Column1)
Column_1 | SIMILARTO |
|---|---|
xyz | true |
x | false |
%(y|a)% | true |
(y|z)% | false |