I have a string of data similar to this format:
405875651 5GEORGIA WARNER ROBBINS 3006054125 6785429874YA2SOUTH CAROLINA YORK 2922165412
i.e. phone number, Y/blank, digit,state (1 or 2 word), location (1 or more words) zipcode and it can repeat up to 6 times.
I'm trying to break it apart using the token method in the REGEX function in Alteryx.
[^\D]+ does it mostly but it omits the Y/blank. Any help would be appreciated.
Solved! Go to Solution.
Hi @alexlyle ,
Attached is an example almost done!! The only problem is the separation of state and location, since it is possible to have 2 words state with 1 word location and 1 word state with 2 words location, it is impossible to check that with regex.
So I thought about another way and inserted my idea in the example.
Take a look and let me know if this works for you.
Best,
Fernando Vizcaino
Thanks Fernando,
I had not though to try the lookup tool. I'm going to have to look into that.
-Alex
Fernando, this is very helpful. I don't have much experience with the Find/Replace tool. Thanks for the lesson.