REGEXMATCH

This function is only available in Coherent Assistant and not implemented into Neuron. Spark services created with this UDF will not include this functionality.

Regular expression enabled MATCH() function to search for a specified item in a range of cells, and then return the relative position of that item in the range.

Syntax

CS.SPARK_REGEXMATCH(find_regex, within_text, [start_num])

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 [e-mail]. I live in New York, and I work as a software engineer. My hobbies include reading, hiking, and photography. Contact me at [phone].

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)	[e-mail]