[ https://issues.apache.org/jira/browse/CALCITE-5979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jerin John updated CALCITE-5979: -------------------------------- Description: Add support for [REGEXP_REPLACE |https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_replace] function from BigQuery. *{{REGEXP_REPLACE(value, regexp, replacement)}}* Returns a STRING where all substrings of {{value}} that match regular expression {{regexp}} are replaced with {{{}replacement{}}}. backslashed-escaped digits (\1 to \9) can be used within the {{replacement}} argument to insert text matching the corresponding parenthesized group in the {{regexp}} pattern. Example (added one space between \ \ to override md formatting): {{SELECT REGEXP_REPLACE("abc'", "b(.)", "X\ \1") as result;}} |result| |aXc| was: Add support for [REGEXP_REPLACE |https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_replace] function from BigQuery. *{{REGEXP_REPLACE(value, regexp, replacement)}}* Returns a STRING where all substrings of {{value}} that match regular expression {{regexp}} are replaced with {{{}replacement{}}}. backslashed-escaped digits (\1 to \9) can be used within the {{replacement}} argument to insert text matching the corresponding parenthesized group in the {{regexp}} pattern. Example (added one space between \ \ to override md formatting): {{SELECT REGEXP_REPLACE("abc'", "b(.)", "X\ \1") as result;}} |result| |aX| > Add REGEXP_REPLACE function (enabled in BigQuery library) > --------------------------------------------------------- > > Key: CALCITE-5979 > URL: https://issues.apache.org/jira/browse/CALCITE-5979 > Project: Calcite > Issue Type: Task > Reporter: Jerin John > Assignee: Jerin John > Priority: Major > Labels: pull-request-available > > Add support for [REGEXP_REPLACE > |https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_replace] > function from BigQuery. > *{{REGEXP_REPLACE(value, regexp, replacement)}}* > Returns a STRING where all substrings of {{value}} that match regular > expression {{regexp}} are replaced with {{{}replacement{}}}. > backslashed-escaped digits (\1 to \9) can be used within the {{replacement}} > argument to insert text matching the corresponding parenthesized group in the > {{regexp}} pattern. > Example (added one space between \ \ to override md formatting): > {{SELECT REGEXP_REPLACE("abc'", "b(.)", "X\ \1") as result;}} > |result| > |aXc| -- This message was sent by Atlassian Jira (v8.20.10#820010)