Extract text up to 3rd - from a string

Question

Hi,

I want to extract part of a string in the following two examples:

Example 1: TE00939 - Test1

Example 2: TE009-9-3 - Test2

I know how to extract part of the string up to the 1st '-' and get the following result: TE00939 (from the 1st example).

But I'm not sure how to tell Alteryx to extract TE009-9-3 from Example 2.

Any thoughts please?

apathetichell · Accepted Answer

regex_replace([field],'^(.*)\s-\s.*$','$1')

jrlindem · Accepted Answer

@apathetichell's solution is the cleanest solution.

But for me, its Friday and regex hurts my head on most normal days, let alone the Friday before a Holiday (in the U.S.), so here's another option using a FORMULA + TEXT-TO-COLUMNS just for fun:

flying008 · Accepted Answer

Hi, @MAT_84

FYI.

Left([Txt], FindString([Txt], ' '))