How to Extract a Specific Piece of Text using SQL
In this video I teach you how to pull specific bits of text from larger strings using SQL. I walk you through using SQL functions like LEFT, RIGHT, STRPOS, and SUBSTR to do data cleaning tasks like neatly separating usernames and domains from emails. I also cover more tricky stuff, like extracting text between two characters, making sure you're equipped to tackle a variety of text extraction challenges!
📚 Materials/References:
SQL Queries & Datasets from the Video: https://bit.ly/3VIBc32
Join My Newsletter: https://newsletter.thequery.jobs
Set Up BigQuery Playlist: • BigQuery Tutorial for Beginners (Part 1 of...
BigQuery Docs: https://cloud.google.com/bigquery/doc...