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?
Solved! Go to Solution.
regex_replace([field],'^(.*)\s-\s.*$','$1')
@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:
thanks all! Still new to alteryx so trying to get my head around. I'll get there soon :)
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |