Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

REGEX

alexlyle
8 - Asteroid

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.

3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

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

alexlyle
8 - Asteroid

Thanks Fernando,

I had not though to try the lookup tool. I'm going to have to look into that.

-Alex

alexlyle
8 - Asteroid

Fernando, this is very helpful. I don't have much experience with the Find/Replace tool. Thanks for the lesson.

Labels