Alteryx designer Discussions

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

REGEX

Highlighted
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.

Highlighted
Alteryx Certified Partner

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

Highlighted
8 - Asteroid

Thanks Fernando,

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

-Alex

Highlighted
8 - Asteroid

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

Labels