Extract text up to 3rd - from a string

[MAT_84]

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 solution]

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

[Kottapally_Ramesh]

Hi Mat,

you try any of the below functions in formula tool and attached sample workflow for your reference.

Trim(Left([Input], FindString([Input], " - ")))


REGEX_Replace([Input], " - .*", "")

[jrlindem · Accepted solution]

@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 solution]

Hi, @MAT_84 

FYI.

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

[MAT_84]

thanks all! Still new to alteryx so trying to get my head around. I'll get there soon :)