Text to Column using Width

[Mirai (Mirai Kuriyama)]

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?

[Yoichi]

Hi,

If possible, can you share your data as a text file?

Regards,

[Mirai (Mirai Kuriyama)]

Hi Yoichi, sure. It contains some sensitive data so I remove most of the rows
Test.txt (606 Bytes)

[Yoichi]

Hi,

Thanks for sharing. How about the following?

Sample20220412-3.zip (7.6 KB)

Regards,

[Mirai (Mirai Kuriyama)]

It works flawlessly! I never have thought generate data table has this function. Thank you so much