Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How do I parse data at varying places?


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.  




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. 




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


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


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