Summary
In this video we filter based on matching text patterns using RegEx.
Tab in example file: RegEx
This video introduces regular expressions (RegEx) which is used to match text patterns.
REGEXTEST – Checks if a value matches a pattern and returns TRUE or FALSE.
The syntax for REGEXTEST is:
=REGEXTEST(text, pattern, [case_sensitivity])- text – The text to search within.
- pattern – The pattern to find.
- [case_sensitivity] – 0 = Case Sensitive; 1 = Case Insensitive.The default is 0.
The common RegEx options are:
- ^ – Starts with
- $ – Ends with
- .* – Any number of characters
- .{3} – Three characters