[UDF] Add strtok function for teradata emulation

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.07k stars 269 forks source link

Closed bdw-g closed 9 months ago

bdw-g commented 9 months ago

STRTOK in Teradata is a bit special (or rather, it's similar to libc's strtok, and that's a bit special):

ignores leading delimiters
ignores duplicate delimiters
returns NULL for out-of-band fields
except if the whole string consists of delimiters, and you want the first token, in which case it returns an empty string