In this video tutorial, we walk through key building blocks of regular expressions using the incredibly powerful REGEXEXTRACT function in Google Sheets. To follow along, make a copy of this Sheet. Topics covered:
A little bit of regex knowledge can go a long way. Regular expressions are supported in all major programming languages, and they are also available as a text/field matching option in many Google products including Analytics, Data Studio, and Tag Manager. For example:
A few resources mentioned in the video:
And here’s a post I wrote a while back about searching-and-replacing in Sheets with regular expressions.
Reaching AI limits and recognizing human intelligence plus lots of new tools & resources for…
New in digital marketing this month: towards ads in ChatGPT, TikTok to get American owner,…
New: ChatGPT using Google's index, LinkedIn and TikTok platform updates.