community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

How do I parse data at varying places?

Meteoroid

I have a column of data where the country, firs name and last name are in the same column.  I want the country in one column, the first name in another column and last name in yet another column.  My problem is that some of the countries contain two words such as United States or South Africa so when I parse using a space as delimiter, it is putting United in one column and States in another.  See attached Winner column.  

 

 

Fireball

I could not access your sample files.  But here is an example that might help.

 

I used a RegEx tool set to parse with the following regular expression. 

 

([[:upper:]].*?\s[[:upper:]].*?)\s([[:upper:]].*?$)

 

This will work for single word first and last names paired with country names of any length.  

 

I find regex101.com a great tool to use when trying to work out the right expression.

Meteoroid

Excellent, thank you so much.  So glad to know about regex101.com!

Labels