Alteryx Designer Discussions

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

Parsing Data to Respective Column

6 - Meteoroid

HI, I am having difficulties on parsing the data where it needed to be parsed to columns. I used the RegEx tools for parsing the data, however my regular expression are not working. I hope you guys can share with me the right expression needed. Attached below are excel file for the original data.Thank you for your help and really appreciated it.


This are the sample output required:

Parsing Output.PNG



11 - Bolide

Hi @mohdhafiz



Regex: (.*?)\s(.*?)(\d+\.\d+|n\/a?).*?(\d+\.\d+|n\/a)\s+(\d+|n\/a)(.*?)(\d+\.\d+|n\/a?)\s+(\d+\.\d+|n\/a?)

I got rid of any leading .(stops) prior to regex to make life easier.


Let me know how you get on.

21 - Polaris

Hi @paulfound 


This is amazing. Can you suggest some resources for learning advance level Regex.

16 - Nebula
16 - Nebula

HackerRank has a decent course:


And there are some decent online tools like and



21 - Polaris

Thanks @jdunkerley79 


I will post a question please reply over there so that the post is easily findable.

11 - Bolide

To be honest I've just learned through trial and error. 


Not sure how advanced this is either to be honest, its repetition really and long, some better RegEx'ers may have a better way of . 


I like to use online RegEx testers like (This doesn't do Perl, Alteryx uses Perl) I find that you can mess around and find ways to capture and group the data.


Hope this is of some help.