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

Using regex with Text To Columns

roadhouse
7 - Meteor

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

MarqueeCrew
19 - Altair
19 - Altair

@roadhouse,

 

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.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

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

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

Labels