Learn to use RegEx in Google Sheets in 10 minutes

Опубликовано: 13 Октябрь 2020
на канале: Jonah Lawrence • Dev Pro Tips

16,413

401

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

Смотрите видео Learn to use RegEx in Google Sheets in 10 minutes онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Jonah Lawrence • Dev Pro Tips 13 Октябрь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 16,413 раз и оно понравилось 401 людям.

833