Hi guys, I’m trying to automate a process where it will convert a text file into an excel by using column width. I tested the text to column activity but it only allows me to separate all columns by only 1 width. My data column have different width as below.
Any idea on how to make this work?
Hi,
If possible, can you share your data as a text file?
Regards,
Hi Yoichi, sure. It contains some sensitive data so I remove most of the rows
Test.txt (606 Bytes)
It works flawlessly! I never have thought generate data table has this function. Thank you so much 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
