Regular expressions can be used to filter or replace strings with certain patterns. Exasol supports the Perl Compatible Regular Expressions (PCRE Perl Compatible Regular Expressions) dialect, which has a powerful syntax and exceeds the functionality of dialects like POSIX Portable Operating System Interface [for Unix] Basic Regular Expressions (POSIX BRE) or POSIX Extend Regular Expressions (POSIX ERE). This chapter describes the basic functionality of regular expressions in Exasol. Detailed information about the PCRE dialect can be found on www.pcre.org.
Regular expressions can be used in the following functions and predicates: