Is the text tabular in ID? Or a table?
Put a text cursor in a story, but don't select anything, then go to File > Export and choose Text Only. Excel out to be able to recognize it as delimited text and build the spreadsheet.
i believe its tabular. I found a way to export tables to excel, but the guy who held my job before me didnt use tables when creating the catalog. Im assuming he put all the text in by hand because there are a countless amount of different text boxes. Because of this, when i attempt to use the method you just outlined all that it exports is the text contained in that particular text box. I need to export the headings, descriptions, part #'s, and detailed descriptions
Acrobat hasn't been any help either.
Really? Open pdf in Acrobat (I use X Pro), File>Save As> Spreadsheet> Microsoft Exel Workbook.
Works nicely for me with text-only sheets. Not sure about complex ones, with images, etc.
However, you should give it a try.
Crossposting... Huh, if it's NOT tables in fact, than, I'm afraid, you're hard luck...
Message was edited by: winterm
Make a copy of the file for backup, then go to Rorohiko.com and look for their Text Stitch script. That should be able to knit the whole thing into a single story.
If the data is tabular inthe frames I think that should do the trick.
Thanks, I found a script to convert to CSV and then ran the Text Stitch. After that, i exported as text only, and then imported into Excel using From Text button. This gave me, what i think, is a workable spreadsheet. I have to go in run the same process for every two page spread but its much easier than copy and pasting