Uploaded March 2015 | Updated September 2026, 8 minutes ago
In this video I demonstrate how to find and replace special characters in MIcrosoft Word, like carriage returns, to convert columns of values from Excel into comma-separated lists.
In this video I demonstrate how to find and replace special characters in MIcrosoft Word, like carriage returns, to convert columns of values from Excel into comma-separated lists.
![Regex for Marketers in Plain English with Real World Examples [VIDEO]](https://i.ytimg.com/vi/4BXD6iWmkCA/mqdefault.jpg "Regex for Marketers in Plain English with Real World Examples [VIDEO]
Link to blog post: http://bit.ly/regex4marketers. Breakdown of video with links to each section (regex character) 👇.
Are you intimidated by regular expressions? Just think of them as filters on that would fail a blood test. No but seriously, regex enables you to filter using patterns. For each one I share gotchas, easy ways to understand what they do, and practical examples of tasks you can accomplish with regex. Make sure you pull the lists from my blog post if you want to follow along! Over the next few videos Ill show examples for how you can use regex in Google Analytics, Google Docs, Google Sheets, Tableau, SQL, and Screaming Frog.
Breakdown of Regex Characters in Order of Appearance:
00:34 - |
04:00 - .
04:00 - *
04:00 - +
06:18 - [ ]
06:18 -
09:37 - d
10:55 - ?
14:09 - { }
15:50 - ^
15:50 - w
19:20 - ( )
22:08 - $
24:51 - [^ ]
29:26 - s
Additional Exercises
34:21 - Britney Spears Misspellings
38:21 - URIs with Query Parameters in GA
41:23 - Filter for Search Terms with 3 Words in GA
43:08 - Identify Staging Servers in GA
44:14 - Extract Zip Codes")
