Hi I have a document that I want to turn into an excel file that is on pdf. I have already run a OCR to turn everything onto text. Unfortunately this file is not in a table already and when I transfer the wrong information goes into the wrong cells. I would like to split some text boxes and delete some text boxes so when I transfer the document to the excel the right data will be in each cell. How do I do this.
PS Oh to make it harder the document is over 1000 pages so I can't do it by hand but I figure if I learn how to do it by hand then their should be a way to program acrobat to do it to.
Thanks
Transferring a file (that is not formatted like a table) into an excel document
2011-07-15 20:36:03
My Product Information:
Acrobat Pro 9.2, Windows
Acrobat Pro 9.2, Windows
2011-07-16 19:11:19
#2
Thanks that's helpful for moving around some of the things I also need something some of that data from one cell to another because basically almost all the data when it gets transferred to excel is under one column but some of the text that adobe reconizes I don't want (barcodes) and some of the other stuff I want to move into rows so instead of reading
name
addess
city
zip
phonenumber
name2
etc
I want it to read
name, address, city, zip, phonenumber
name2, etc
with the commas delineating each cell in a row. Obviously I can't just row -->column because I want to keep all the names in one row and all the addresses in one row etc.Thanks for the help,
Cameron
name
addess
city
zip
phonenumber
name2
etc
I want it to read
name, address, city, zip, phonenumber
name2, etc
with the commas delineating each cell in a row. Obviously I can't just row -->column because I want to keep all the names in one row and all the addresses in one row etc.Thanks for the help,
Cameron
2011-07-18 02:30:56
#3
It might be possible to script it, but that really depends on the way the file is set up.
If you wish, you can contact me personally by email and I'll have a look at the file.
If you wish, you can contact me personally by email and I'll have a look at the file.
I don't do Excel support, but I use it on occasion. Have you tried using Data > Text to Columns. Often when I'm converting data I may need to have the space between words turn each word into it's own column. For example, when extracting First Name, Last Name and email my text may look like this:
Kelly McCathran [email protected]
Using Text to Columns will put each in it's own column. This Microsoft article may help:
http://office.microsoft.com/en-us/excel-help/split-names-by-using-convert-text-to-columns-HA001149851.aspx
Kelly McCathran
Adobe Community Expert
Certified Technical Trainer+