So what is wrong with getting 3 'eternal lifes' - just more time to play with VFP!!! I believe they have a PDF2Excel version but I've only used the PDF2TXT version. I have not run into a PDF yet that I have been unable to parse. And there have been some challenges. This tool has an interactive as well as command line interface with several conversion options, including HTML. You can convert single files or use wildcards: [*.pdf] to [*.txt] I needed support once and got a CORRECT answer back the same day via email.
Things are going very well, but as always, subject to change with almost no notice! 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 12:07 PM To: [email protected] Subject: Re: [NF] PDF to CSV or Excel 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 [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.
