View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Working from data converted from a pdf file

On Wednesday, April 6, 2016 at 3:35:33 PM UTC-5, GS wrote:
https://www.dropbox.com/s/xre6rh9f6g...aders.csv?dl=0

That is the csv file of the way I layed out how I wanted it. I
can't find much of a pattern for how it was in the pdf file


You can probably assert blame for any inconsistency to the Nuance
converter app. Raw data is always going to be more accurately
structured and so better to work with if you want consistent
reliable/dependable results.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Well, I know how to take a pdf file we received in email, and rather
than run it in nuance, I can save it as a txt file. I opened the pdf
in adobe acrobat reader, and did a file saveas other. Here that is,
does that do any good?

https://www.dropbox.com/s/gldyhdckpf...02016.txt?dl=0


Much, much better! Why can't this be created initially directly from
the app that printed to PDF? It certainly would improve your
productivity by orders of magnitude compared to having to decipher data
that was parsed using OCR technology. I highly recommend you *insist*
the data be sent as a text file *from the source* so you get it 'raw'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion