Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Using regex with Text To Columns

Highlighted
Alteryx Certified Partner

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@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.
Alteryx Certified Partner

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

Labels