Geek Culture
Published in

Geek Culture

Working with Strings in BigQuery

What you have to know when working with String Functions

Photo by Pawel Czerwinski on Unsplash

Who is not familiar with this situation? What was that thing again with the correct string function? Just google it and next time it will end so again. Here are some of the use cases, that I often come in touch with and which I wanted to write down, in the hope of not to have to google them again.




A new tech publication by Start it up (

Recommended from Medium

Renaming in Rails

How to Export Data on Excel from the EOS Public Database

Launching An EC2 instance on Amazon Web Services.

1000 Followers on Mobile App Development Publication

VS Code Remote Development

Docker Logging: Where Are Container Logs Stored

Why mobile app hosting is fundamental for your versatile application?

Getting Started with Istio

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


Big Data Enthusiast based in Hamburg and Kiel. Thankful if you would support my writing via:

More from Medium

How to use the Qualify Function in BigQuery SQL

JSON in Google BigQuery — Finally

SQL String Templating in BigQuery: Four Methods

Data processing with Dataflow SQL (part 2/2)