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: https://youtu.be/6JoRBsHwsPY
► RegEx Essentials Part #2: https://youtu.be/GTUlkkNhvok

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/d/1LkhqhGgiXDb4x1ouZeJOUwKlVd3LJpJDDMgBe12RQcU/edit?usp=sharing

🔢 More RegEx Essentials Tutorials - Learn to code with Regular Expressions!
► https://www.youtube.com/playlist?list=PL9YUC9AZJGFGB7qnffZD0Iu7kntOSgfS7

💻 More tutorials
► https://www.youtube.com/playlist?list=PL9YUC9AZJGFHTUP3vzq4UfQ76ScBnOi-9

🙋‍♂️ Find me on other channels
Discord 🗨️ https://bit.ly/dpt-discord
Twitter ✍ https://twitter.com/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

Тэги:

#regular_expressions #regular_expression #regex #regular_expression_tutorial #regex_tutorial #regex_tutorials #tutorial #expression #regex_intro #introduction #what_is_regex #what_is_a_regular_expression #javascript #re #python_regex #google_sheets #programming_tutorial #how_to #advanced_regex #gsheets #sheets #spreadsheets #regex_in_excel #excel #regexreplace #regexextract #regexmatch #google_sheets_tutorial #regex_in_google_sheets #normalization #google_sheets_tips_and_tricks #formulas

Скачать видео