Using regex with Text To Columns

[roadhouse]

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

[MarqueeCrew · Accepted solution]

@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

[roadhouse]

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