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. [Screenshot 2022-04-12 094305] Any ide…

Hi, Thanks for sharing. How about the following? [img20220412-4] [image] Sample20220412-3.zip (7.6 KB) Regards,

Text to Column using Width

Yoichi (Yoichi) April 12, 2022, 2:08am 4

Hi,

Thanks for sharing. How about the following?

Regards,

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Text file to excel activity error Activities excel	2	500	December 5, 2022
Read Text File into Data Table Activities excel , activities , question	4	3164	April 15, 2021
Text to Columns Google Sheet Studio studio , question , new_feature_request	4	1107	April 17, 2022
Problem With Text File To Data Table To CSV File Conversion Activities database , uiautomation	14	1770	February 22, 2024
Convert Text file to Excel file Studio datatable , studio , question , activities_panel , data-manipulation	5	1750	November 22, 2021