REGEXMATCH
Syntax: CS.SPARK_REGEXMATCH(find_regex, within_text, [start_num])
Regular expression enabled MATCH() function to search for a specified item in a range of cells. Returns the matching string.
Parameter
Description
find_regex *
Regular expression pattern you want to match the within_text argument. It should be a valid regular expression string.
within_text *
Text string in which you want to search for a regular expression pattern. It should be a valid text or cell reference.
start_num
If specified, this argument allows you to specify the starting position of the text.
Example
Copy and paste the text below into cell A1 in a new worksheet.
Hello, my name is John Doe. My email is john.doe@example.com. I live in New York, and I work as a software engineer. My hobbies include reading, hiking, and photography. Contact me at +1234567890.Copy and paste the regular expression below to the cell A2.
[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}Formula
Result
=CS.SPARK_REGEXMATCH(A2,A1)
john.doe@example.com
Last updated
