I converted pdf data into text files and in the pdf the data is formatted as columns. When converting text file, some of the data is placed in the wrong column. How can I get the data as the requirement. I attached the screenshoots and text files as below.
This is the input format.
I want to combine as below. for example: I want to combine “AMI/CC-” and “001755/0816/YGN” as these are the customer code. The last part of the customer code is placed into name column when converting text from pdf.
I also attached the text file. If there is any solution or workaround, please let me know. Thanks.
And then when I convert text data into data table using generate data table. I got the following output (excel).
Hello @Zaw_Win_Htun1 . Kindly refer this flow. It is post processing process, after you write into excel sheets you can use this flow.
Conditions, “/” sholud contains 3. other wise merge data of curent row column 2 and next row of column1 Forum_DataMismatch.zip (87.8 KB)