SQL regular expression functions

The InfluxDB SQL implementation uses the POSIX regular expression syntax and supports the following regular expression functions:

• regexp_replace

regexp_replace

Replaces substrings in a string that match a regular expression.

regexp_replace(str, regexp, replacement, flags)

Arguments

• str: String column or literal string to operate on.
• regexp: Regular expression to match against.
• replacement: Replacement string.
• flags: Regular expression flags that control the behavior of the regular expression. The following flags are supported.
  • g: (global) Search globally and don’t return after the first match.
  • i: (insensitive) Ignore case when matching.

SELECT DISTINCT
  room,
  regexp_replace(room::STRING, '\sRoom', '', 'gi') AS regexp_replace
FROM home