filmov
tv
Use of Regular Expression Extract in Google Sheets. RegEx functions

Показать описание
Video tutorial series about Google Sheets RegEx functions, how to work with text suing REGEXEXTRACT, REGEXMATCH, REGEXREPLACE functions. You will learn all the basics of regular expression, how to extract text using REGEXEXTRACT, how to replace text using REGEXREPLACE, how to make logical tests and use it for conditional formatting using REGEXMATCH.
Syntax
REGEXEXTRACT(text, regular_expression)
text - The input text.
regular_expression - The first part of text that matches this expression will be returned
Syntax
REGEXEXTRACT(text, regular_expression)
text - The input text.
regular_expression - The first part of text that matches this expression will be returned