Text file manipulation

Help Community
, , ,
1

Dear Experts,

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.

image
image1358×470 22.7 KB

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.
image
image1364×489 26.8 KB

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).
image (1)
image (1)993×699 25.7 KB

2

If there is any solution or work around, please let me know. thanks

3

@Zaw_Win_Htun1 , Kindly share the Excel file

4

Hello @Gokul_Jayakumar Kindly receive the excel file. This is the input format excel file.
Page264_ SAW KA BAW MU IA(O)0671 .xlsx (10.4 KB)
This is the excel format I want to get.
Page264_ SAW KA BAW MU IA(O)0671_output.xlsx (10.4 KB)

5

This is the input text file I used to generate data table. I will share it for reference.
Page264_ SAW KA BAW MU IA(O)0671 .txt (3.1 KB)

6

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)

1 Like
7

Dear @Gokul_Jayakumar . Thanks for your solution. It’s the solution I want. I really appreciate for your effort. Best Regards.

8

@Zaw_Win_Htun1 Pleasure is Mine
If you get answer, Kindly mark it as solution, because other can utilize it with same issue
image

Happy automation

Regards,
Gokul Jai

9

I marked the workflow as solution. Thanks for your help.

10

@Zaw_Win_Htun1 , It will helps someone with same issues. Great job.

Happy Automation

Regards,
Gokul Jai

11

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