Text file to excel activity error

Help Activities
1

Hi, i already succeed in to convert text file to excel using studio x. But after i try to run, there is a few data that not the same as i do it manually using excel. Firstly, the first 3 data is combine into 1 column. Second is suddenly there is 3 column added

During the manual, i use fixed width. Do u have any idea on how i want the text file to be converted into excel more good? Because i want to cut the step. I know that i can combine the column but more prefer to just have the output like i done manually using fixed width
This is what happen in my output please refer to the image

image
image1125×2001 248 KB

2

Please provide the format in the generate datatable by counting the number of characters in the text you provided

cheers

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.