ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Using regex with Text To Columns

7 - Meteor

Is it possible to define your delimiter with regex in the Text To Columns tool?

19 - Altair
19 - Altair



How about this.....


Use regex to convert patterns to a single delimiter, '|' (pipe).  Then use the text to columns tool with the pipe as your delimiter.


I think that it accomplishes what you are setting out to do.  Otherwise, I think that you would need to know how many delimiters are present and you could use the regex tool and use the parse option.




Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
7 - Meteor

thanks... I would have made that so much more complicated left to my own devices 🙂