On 2/14/2014 11:34 AM, Dennis Schuette wrote:
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
Dennis: How are you doing? I've used three different converters with no success. Two of them (including the one you recommend) gave me three ankhs http://en.wikipedia.org/wiki/Ankh.
-- Jeff Jeff Johnson [email protected] SanDC, Inc. 623-582-0323 Fax 623-869-0675 http://www.san-dc.com
_______________________________________________ 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.
