Indicates that the adjacent character should be interpreted literally rather than as a regex metacharacter. Matches the enclosed characters in any order anywhere in a string.Ĭreates a range of characters within brackets to match anywhere in a string. Matches the enclosed characters in exact order anywhere in a string. Matches the adjacent characters at the end of a string. Matches the adjacent characters at the beginning of a string. Matches the preceding character 0 or more times. Matches the preceding character 1 or more times. Matches the preceding character 0 or 1 times. Matches any single character (letter, number, or symbol). See google/RE2 Github documentation for complete regular expression syntax. Returns text with leading and trailing spaces removed.

Returns true if the field or expression begins with the specified text, otherwise returns false. Returns a number of characters from the end of a specified string. Returns a copy of the original text with all occurrences of the search text substituted with the replacement text. Returns a number of characters from the beginning of a specified string. Returns true if the field or expression ends with the specified text, otherwise returns false. Returns true if the specified text is found in the field or expression, otherwise returns false. The following functions provide regular expression-like functionality without requiring you to know regexp syntax. Before using a regexp function, consider whether using a simpler text function will achieve your goal. Replaces all occurrences of text that match the regular expression pattern in the input value with the replacement string.Īlternatives to using regular expressionsĬonstructing regular expressions can be complex. Returns true if the input value matches the regular expression pattern, otherwise returns false.

Returns the first matching substring in the input value that matches the regular expression pattern. Returns true if the input value contains the regular expression pattern, otherwise returns false. You can also use the following regular expression functions in calculated field formulas: REGEXP_CONTAINS You can use regular expressions to create more flexible filters in charts and controls. A regular expression (regexp) is a specific sequence of characters that broadly or narrowly matches patterns in your data.

Regex match string