TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:Exporting Acrobat columns into Excel From:csg -at- telecable -dot- es To:"TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com> Date:Sat, 23 Mar 2002 9:54:55
I got this large Acrobat5 document (255 pages) written in a two-column
format. Actually is a glossary: the phrases in the right-hand column
describe the terms in the left-hand column. I want to export both columns
independently or separately, to create an Excel/Access table with actual
records and fields. Each record (line) would have two fields(columns):
"term" and "definition" That way the table would be more manageable and
editable. It happens that whatever Acrobat export method I choose I always
end up with a one-field record. I am unable to separate the Acrobat text
line into two actual fields, one per column. As far as I know, the
text/column/table select tools work at the page level. When saving the
document as a RTF, TXT, I get a long list of single-field records,
alternatively containing a chunk of the original text from the left column
and a chunk of the original text from right column. It seems Acrobat saved
the data as pages, and then converted the data into individual single-line
records independently of the original position (left or right column). I
know I am missing something here, but I am trapped moving around a circle.
How would you independently export Acrobat text columns into Excel? Any
ideas?
=====
Carlos
csg -at- telecable -dot- es http://www.telecable.es/personales/csg
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PC Magazine gives RoboHelp Office 2002 five stars - a perfect score!
"The ultimate developer's tool for designing help systems. A product
no professional help designer should be without." Check out RoboHelp at http://www.ehelp.com/techwr
---
You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit http://www.raycomm.com/techwhirl/ for more resources and info.
