Hi everyone,
So i have a 50 page pdf price list and i need to import it to my DB.
The table in the pdf is weirdly structured, so it has 4 records then a 'line' then anther 4 record etc etc
What happens when importing it (the whole thing) is that all 4 records in that section end up being put in the same record.
eg:
Item - Cost
A $5.50
B $7.00
C$9.00
D $8.00
Import:
A B C D | $5.50 $7.00 $9.00 $8.00
thtne
E F G H
etc etc
however IF i just go into teh pdf and copy 4 rows in one section it does it fine and copies ok manually!!
Ive tried CSV, txt, online conversion...
Any ideas would be great.
Getting an excel version off the company is going to be near impossible.