![]() ![]() Returns the portion of the string that matches the regular expression pattern. This function is available for Text File, Google BigQuery, PostgreSQL, Tableau Data Extract, Microsoft Excel, Salesforce, Vertica, Pivotal Greenplum, Teradata (version 14.1 and above), Impala 2.3.0 (through Cloudera Hadoop data sources), Snowflake, and Oracle data sources.įor Tableau data extracts, the pattern must be a constant. ![]() Returns true if a substring of the specified string matches the regular expression pattern. See the Regular Expressions (Link opens in a new window) page in the online ICU User Guide. For Tableau extracts, regular expression syntax conforms to the standards of the current International Components for Unicode (ICU), an open source project of mature C/C++ and Java libraries for Unicode support, software internationalization, and software globalization. This function is available for Text File, Hadoop Hive, Google BigQuery, PostgreSQL, Tableau Data Extract, Microsoft Excel, Salesforce, Vertica, Pivotal Greenplum, Teradata (version 14.1 and above), Snowflake, and Oracle data sources.įor Tableau data extracts, the pattern and the replacement must be constants.įor information on regular expression syntax, see your data source's documentation. Returns a copy of the given string where the regular expression pattern is replaced by the replacement string. ![]() REGEXP_REPLACE(string, pattern, replacement) ![]()
0 Comments
Leave a Reply. |