I need to parse the field Text.
But I only want to parse those rows in text that meet a certain pattern.
The target rows will always contain all caps.
The target row has two groups I wish to pasre.
Using the Regex Parse tool i tried the following expression:
^([A-Z0-9]{3,4})\s([A-Z\s&-]*[A-Z])$
>>>> This works 99.9% of the time. BUT in the case where Text = "food insecurity" the above expression ignores the capitalization requirement and returns "food" in Out_1 and "insecurity" in Out_2. This is not what I want. What am I doing wrong?
Desired Outcome....
Text | Out_1 | Out_2 |
1A2Y TACO - CRUNCHY | 1A2Y | TACO - CRUNCHY |
2500 | ||
Unjustified growth | ||
BSIM TRAINING OPS | BSIM | TRAINING OPS |
food insecurity | ||
111 FIELD OPS | 111 | FIELD OPS
|
465464 |
|
Solved! Go to Solution.
There's an optional field you can throw into the regex functions which checks for case - otherwise it ignores it. See - https://help.alteryx.com/current/en/designer/functions/string-functions.html#idm45439286134896 (icase)
@apathetichell I always forget about that preset. Why does it even exist