Learn to use RegEx in Google Sheets in 10 minutes
Tutorial for using Regular Expressions in Google Sheets (extract, replace, and match)
❤ Subscribe: http://bit.ly/SubscribeDPT
Learn How To Build Regular Expressions
► RegEx Essentials Part #1: • RegEx Essentials - What you need to k...
► RegEx Essentials Part #2: • Regex Essentials - Advanced Expressio...
In this tutorial, I will show you how to use Regular Expressions in Google Sheets. including the use of the REGEXEXTRACT, REGEXREPLACE, and REGEXMATCH functions.
Regular Expressions are a very useful tool for easily manipulating strings and testing input. It is one of the most useful skills and one of the toughest to master. I hope this video will get you familiar with the common usages of Regex so you can start using it everywhere.
📺 In this video:
0:00 - Intro
0:34 - Extract text with RegEx
1:36 - Extracting with capture groups
2:45 - Replacing text with RegEx
3:52 - Text Normalization with RegEx
5:03 - Validating input with RegEx
6:48 - Using the case-insenstive flag
9:24 - Conclusion
🧮 Source sheet (feel free to make a copy)
https://docs.google.com/spreadsheets/...
🔢 More RegEx Essentials Tutorials - Learn to code with Regular Expressions!
► • Regex Essentials (Tutorials)
💻 More tutorials
► • Tutorials
🙋♂️ Find me on other channels
Discord 🗨️ https://bit.ly/dpt-discord
Twitter ✍ / denvercoder1
Github 👨💻 https://github.com/DenverCoder1
Sponsor 💞 https://github.com/sponsors/DenverCoder1
One-time donation ☕ https://ko-fi.com/jlawrence
💖 SPONSORS 💖
Get your username or a link to your channel here by sponsoring on Github
▶ https://github.com/sponsors/DenverCoder1
🎁 GET FREE STUFF WHILE SUPPORTING MY TUTORIALS
► https://bit.ly/jlawrencepromos
Watch video Learn to use RegEx in Google Sheets in 10 minutes online without registration, duration hours minute second in high quality. This video was added by user Jonah Lawrence • Dev Pro Tips 13 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 16,41 once and liked it 40 people.