Syntax
LIKESIMILARTO(string: <String>;pattern: <String>)
Description
Allows case-sensitive matching of strings based on comparison with a pattern.
ExamplesThe 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 |