Expression Reguläre Ausdrücke

Owned by Sebastian Greulach
Mar 31, 2022
1 min read

There are two operators and two functions that apply regular expressions.

For example, Matches(PhoneNumber, '^[0-9]{3}-[0-9]{4}$') yields true only when the PhoneNumber is exactly any 3 digits, followed by -, followed by 4 digits (with no additional text before or after).

Both arguments are strings. The first argument is tested against the pattern in the second argument to determine whether it matches.

In local evaluation, the second argument is parsed as a .NET regular expression. If the expression is mapped to SQL, then the pattern must be valid not only for local evaluation, but also for evaluation on the target database. Quino does not translate between regular-expression syntaxes.

Therefore, the patterns in these expressions can only address a common subset of the .NET and target-database pattern syntax.