Splitting a STRING in BigQuery

Photo by Bon Vivant on Unsplash

Splitting a STRING in BigQuery

Splitting a string in BigQuery works pretty much the same as in Excel.

SPLIT works in a similar way as its Excel cousin TEXTSPLIT - taking a string to be split and a delimiter (can be multiple characters), and returns an array of elements.

You can access them using the 0-based index or check out my previous post on more options for accessing array elements in BigQuery.

Found it useful? Check out to my Analytics newsletter at notjustsql.com.