Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5979

Add REGEXP_REPLACE function (enabled in BigQuery library)

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.36.0
    • None

    Description

      Add support for 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

      Attachments

        Issue Links

          Activity

            People

              jerin_john Jerin John
              jerin_john Jerin John
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: