REGEXSEARCH

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 SEARCH() function to locate one text string within a second text string.

Syntax

CS.SPARK_REGEXSEARCH(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_REGEXSEARCH(A2,A1)	41