fix: honor `offset` when `occurence` is 0

GoogleCloudPlatform / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.

https://cloud.google.com/bigquery/

Apache License 2.0

1.13k stars 283 forks source link

Closed shobsi closed 2 months ago

shobsi commented 2 months ago

SELECT bqutil.fn.cw_regexp_replace_4('abaa', 'a', 'A', 1)

Current behavior:

AbAA

Expected behavior:

abAA

danieldeleo commented 2 months ago

Please add unit tests for this UDF in the test_cases.js file

danieldeleo commented 2 months ago

/gcbrun

danieldeleo commented 2 months ago

/gcbrun