I use PDF2TXT, Version 3.2 from
http://www.verypdf.com/app/pdf-to-txt-converter/index.html
It has a command line option that I use to automate parsing 100+ PDF files per
week from various sources - mostly through Outlook automation. Price is very
reasonable.
*code snippet*************************************
*converts SomeFile.PDF to SomeFile.txt
Local lcDir
lcDir="S:\SomeFolder\"
cFile = lcDir+'14 Day Consumption Report.pdf'
lcPDF= ALLTRIM(cFile)
**Extract txt from PDF file
lcTXT = FORCEEXT(lcPDF, 'txt')
lcTxtFile = FORCEEXT(cFile,'txt')
lcPDF2Txt = "C:\Program Files\VeryPDF PDF2TXT v3.2\pdf2txt.exe"
&& DennisLap Win7 32 bit
IF !FILE(lcPDF2Txt)
lcPDF2Txt = "C:\Program Files (x86)\VeryPDF PDF2TXT
v3.2\pdf2txt.exe" && \\DC 64 bit
ENDIF
lcRun = ["]+lcPDF2Txt+[" "]+cFile+[" "]+lcTxtFile+[" -space -format ] && must
surround with " since there may be embedded spaces
TRY
RUN /N &lcRun
CATCH
ENDTRY
IF FILE(lcTxtFile)
USE IN SELECT("cur14Day")
CREATE CURSOR cur14Day ;
(dat C(250),Pen C(10),Lot C(6),Hdct_curr I,Sex C(4),Date_In
D,InWt I, Curr_Wt I,DOF I,Ration C(6),DOR I ;
,Fi7Day N(5,1),Fi14Day N(5,1),FiYTD N(5,1),Lots C(100))
SELECT cur14Day
APPEND FROM (lcTxtFile ) TYPE SDF
ERASE (lcTxtFile)
SCAN FOR !EMPTY(dat)
**populate cur14Day here
ENDSCAN FOR !EMPTY(dat)
ENDIF FILE(lcTxtFile)
*end of code snippet********************************
Customized Business Services, LLC (928) 580-6352
Dennis Schuette Primary:
[email protected]
350 West 16th Street, Suite 309 Alternate:
[email protected]
Yuma, AZ 85364 Map it
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson
Sent: Friday, February 14, 2014 9:08 AM
To: [email protected]
Subject: [NF] PDF to CSV or Excel
Greetings: I have used a number of tools to convert a PDF to CSV with no
success. Has anyone found a Windows application that can do PDF to CSV
conversions reliably? Paid application does not matter at this point.
Thanks,
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
