I need help sorting data from a PDF

[tpthatsme]

OK, it is worst than you thought. When I copy the data from the PDF and paste it into Excel, one PDF row turns into 4 Excel rows. It is like the data string breaks up into 4 pieces. I would like to have each PDF row be one Excel row so that I can use some delimiting rules to make this data usable.

Line 40 returns 4 rows that look like this:

40 02/07/17 15:50:26 0:08 0:32 xxxxxxxxxx6 1xxxxxxxxxx1 0xxxxxxxxxxxxxxxx1
APPLE
IPHONE5S
3xxxxxxxxxxxxx5 MT [NIOP] [2xxxx/0xxxx:-xx.xxxxx:xx.xxxxx:3xx:xx.0]
[FONT=Verdana]
[/FONT]

I want line 40 to be one row, but I am not sure how to tackle this. As you can see, line 43 and 44 do not have IMEI data and therefore do not have the APPLE IPHONE5S to split this row up, so these lines are OK.

Any Ideas??

 

[yky]

I have encountered similar problems before. The following two methods have helped me, though not every time. Still, it's worth to try them. Hope one of them will help you.

1. save the PDF as text then copy from the text file, not from the PDF.
2. copy from the PDF but paste to Notepad first, then, copy from Notepad.