How to Rock Regex Functions in Google Sheets скачать в хорошем качестве

How to Rock Regex Functions in Google Sheets

Based on: https://bit.ly/regex-sheets. Are you tired of manually editing your spreadsheets to extract or replace specific text patterns? Then it's time to learn about using regular expressions—aka regex—in Google Sheets! In this video tutorial, we'll take a deep dive into how to use the REGEXMATCH(), REGEXEXTRACT(), and REGEXREPLACE() functions in Google Sheets with real-world marketing examples. You can also click/tap a minute mark to skip to that section of the video: 00:09 - Using REGEXMATCH() to classify URLs by subdomain 11:04 - Using REGEXEXTRACT() to extract the subdomain 15:29 - Using our new contrived columns in a pivot table and slicer 18:54 - Using REGEXMATCH() to classify keywords as brand or generic 25:12 - Using REGEXREPLACE to switch first and last name and ditch the comma 28:30 - Using REGEXREPLACE to change the formatting of phone numbers