Text file to excel activity error

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

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


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