I use the command line version of PDF2TXT, Version 3.2 from http://www.verypdf.com/app/pdf-to-txt-converter/index.html to extract text, then parse the text in VFP. Their tech support is very responsive (sometimes same day).
It does not work if the PDF generator used embedded fonts. Customized Business Services, LLC (928) 580-6352 Dennis Schuette Primary: [email protected] 49 NW 130 Avenue Alternate: [email protected] Great Bend, KS 67530 -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Paul H. Tarver Sent: Friday, April 28, 2017 10:19 AM To: [email protected] Subject: Reading & Extracting Data From PDF Files Original Thread: Getting count of rows in a text file -- best approach? A couple of times I've heard people mention reading in PDF files using FileToStr and I want to know more about reading and extracting data from PDF files. I do a lot of data conversion and interface work with lots of file formats, but I've not been very successful at importing and extracting data from PDF reports. Obviously a scanned image saved as a PDF would have to be ocr'd first, but is there is a reliable way to extract data from PDF reports and if so, how? I'm sure I don't know all the ends and outs of the PDF format, but when I try, I seem to get a strange mix of formatting details and data combined in a random way. Am I being thick here or is there really a way that I can get any PDF file from any client and then successfully extract the data elements from that format? I'm prepared to be thought of as stupid but be gentle! :) Paul H. Tarver Tarver Program Consultants, Inc. Email: [email protected] -----Original Message----- From: Brant E. Layton [mailto:[email protected]] Sent: Wednesday, April 26, 2017 3:17 PM To: [email protected] Subject: RE: Getting count of rows in a text file -- best approach? |My experience was moving PDF files in and out of SQLServer tables - |found an abrupt truncation at the 16,777,184 mark... Brant Layton| |480.964.1316| On 4/26/2017 12:57 PM, [email protected] wrote: > RE: Getting count of rows in a text file -- best approach? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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.
