K3 Documents

'Like' Regex Values for Use with When Statements

Updated on

Copy and Paste the following formula using your data where necessary.

Description: 

Match a string pattern beginning with "Example" and ending with a combination of Alphanumeric characters and/or whitespace.

\bExample[a-zA-Z0-9 ]+
Click to copy

Description: 

Match a string pattern containing the substring "Example" that is preceded and followed by a combination of Alphanumeric characters and/or whitespace.

[a-zA-Z0-9 ]+Example[a-zA-Z0-9 ]+
Click to copy

Description: 

Match a string pattern containing a "_" that is preceded and followed by a combination of numeric characters.

\d+_\d+
Click to copy
Previous Article Hashing Values
Next Article Convert EU Currency Value Stored in String to Decimal