Is it possible to define your delimiter with regex in the Text To Columns tool?
Solved! Go to Solution.
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
thanks... I would have made that so much more complicated left to my own devices :)