REGEXSEARCH

Returns the location of matched results given a regular expression and string.

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

Syntax

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

• find_regex. Required. This argument represents the regular expression pattern you want to match within the 'text' argument. It should be a valid regular expression string.

• within_text. Required. This is the text string in which you want to search for a regular expression pattern. It should be a valid text or cell reference.

• start_num. Optional 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 [email protected]. 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
=C.SPARK_REGEXSEARCH(A2,A1)	41