View Single Post
  #24   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


At this point we now have 'structured' data in that it resembles
database output. Also, the values are not tab-delimited. It'll take a
bit of time to determine the most beneficial way to parse this how you
want. At least the fieldnames are included, which will be helpful.
Better, though, to get raw data directly to a txt!

--
Garry

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