Hi,
I have text column (only 1 Row data)(comma separated) need to split into columns, but here problem is I want to change (# split into no of columns) in "Text to Columns" tool dynamically.
For example: if have A,B --> number should change to 2 dynamically, by counting delimiters in text
A,B,C -> number should change to 3 dynamically, by counting delimiters in text
* I have no idea whether Regex can do this
Can any one help me on this
Thanks,
Kartheek
Solved! Go to Solution.
Hey @pk1!
I would explore using the Text To Columns tool still, but try splitting to rows instead. Then use the Cross Tab tool to change your rows into different columns. Note you may need to insert a Formula tool before the Cross Tab in order to create a header field.
Hope this helps!
Hi @pk1,
I have a solution for your question, in order to dynamically run Text to Column tool, you would have to create a Batch Macro and with the help of some formula, you would be able to dynamic your output.
Let me know if you have any concerns. Happy Learning.
Thank you!!! It helped me a lot!