IF Regular Expression: find specific digits and return a value

[jf97hernandez]

Dear all,

I am trying to use a formula tool with a RegEx to return a value based on part of a text. More specifically, if the text is 1-187698, the return should be "One"; and if the text is 09-567-09870, the return should be "Two". So pretty much I am trying to look how many digits before the first dash, and based on that condition it returns the corresponding value.

I tried using an IF Left formula to no avail, and also using a regular expression tool to no avail.

Criteria	Solution
1-187698	One
09-567-09870	Two
9-925612	One
15-981-16578	Two
99-909-12986	Two

Thank you in advance for your time and assistance, and I wish you all a great weekend.

Best,

Jf97hernandez

[AngelosPachis · Accepted solution]

Hi @jf97hernandez ,

You can make use of the findstring embedded formula in the formula tool

Have a good weekend 

Regards,

Angelos