Splitting a string in BigQuery works pretty much the same as in Excel.
<code>SPLIT</code> works in a similar way as its Excel cousin <code>TEXTSPLIT</code> - 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 <a target="_blank" href="https://hashnode.com/post/clufovy9d000108l2bzv3gn9t">my previous post</a> on more options for accessing array elements in BigQuery.
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1712870085944/df4cb506-da57-4742-aeec-41c3d2296b39.jpeg" alt class="image--center mx-auto" />
Found it useful? Check out to my Analytics newsletter at <a target="_blank" href="https://www.notjustsql.com"><a href="http://notjustsql.com" class="autolinkedURL autolinkedURL-url" target="_blank">notjustsql.com</a></a>.

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](https://hashnode.com/post/clufovy9d000108l2bzv3gn9t) on more options for accessing array elements in BigQuery.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1712870085944/df4cb506-da57-4742-aeec-41c3d2296b39.jpeg align="center")

*Found it useful? Check out to my Analytics newsletter at* [*notjustsql.com*](https://www.notjustsql.com)*.*

Splitting a STRING in BigQuery

Data Engineer with a passion for transforming complex data landscapes into insightful stories. Here on my blog, I share insights, challenges, and the ever-evolving dance of technology and business.


Explore Datawise - a blog on Analytics, SQL BigQuery and Python. Dive deep into tutorials, case studies, and the latest trends.