RE: Tools: PDF to SQL

Subject: RE: Tools: PDF to SQL
From: "Gilger.John" <JGilger -at- acresgaming -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Fri, 23 Aug 2002 08:26:47 -0700


Matthew Horn advised:
1. Export the PDF as an RTF document
2. Open RTF in favorite word processor (Word).
3. Convert to simple text format (TXT).
4. Buy a book on Perl. Laura LeMay's book will get you up to speed fast. And I believe she is a member of this list.
5. Write script that uses Perl's text-manipulation functions to extract data from text file.
6. Extend this script or write another script that converts the extracted data into SQL statements.
7. Insert SQL into database.

When Gregory Sweet asked:
I've had a request to come up with some method of converting data stored in PDFs to data suitable to be stored in a SqlServer DB. I checked out PDFzone and came up with a product called BCLJade and another called Redwing. Redwing seems to be out because it's not compatible with Acrobat 5 and BCLjade seems very limited (writing each line break as a new record).

------------------------------------------------------------------

My $0.02:

Perl had a database interface module, DBI, that makes this a simple task.

If you don't understand the regexs (text manipulation tools) that will be necessary for this, the second edition of "Mastering Regular Expressions" is now available. It is excellent!

HTH

John Gilger
Senior Technical Writer
Acres Gaming, Inc.


^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Want to support TECHWR-L? Get shirts, bags, hats, clocks,
and more from the TECHWR-L Store. All proceeds support TECHWR-L.
http://www.cafepress.com/cp/store/store.aspx?storeid=techwhirl

Check out the new release of RoboDemo, our easy-to-use tutorial software.
Plus, buy RoboHelp Office in August and save $100 with our mail-in rebate.
Get details and download free trial versions at http://www.ehelp.com/techwr-l

---
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.



Previous by Author: RE: User's, Users, Users'
Next by Author: RE: Not exactly another single source question....
Previous by Thread: RE: Tools: PDF to SQL
Next by Thread: RE: Tools: PDF to SQL


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads