Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.excel.programming > #108732

Re: Working from data converted from a pdf file

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Working from data converted from a pdf file
Date 2016-04-06 17:24 -0400
Organization A noiseless patient Spider
Message-ID <ne3uk2$prv$1@dont-email.me> (permalink)
References (11 earlier) <f2a3c416-b903-4a59-baea-c30e23ab0619@googlegroups.com> <ne3pvj$7uc$1@dont-email.me> <6efc9b5d-cd09-46bf-9cd7-e4dea3ba1d9a@googlegroups.com> <ne3roa$eqf$1@dont-email.me> <ce4a6416-0819-4b37-8d50-98eccad881a0@googlegroups.com>

Show all headers | View raw


> On Wednesday, April 6, 2016 at 3:35:33 PM UTC-5, GS wrote:
>>> https://www.dropbox.com/s/xre6rh9f6gugt4l/Delimited%20file%20of%20headers.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/gldyhdckpf7cch5/Check%20Detail%20March%2031%2C%202016.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

Back to microsoft.public.excel.programming | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 08:23 -0700
  Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 12:21 -0400
    Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 11:13 -0700
      Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 15:07 -0400
        Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:17 -0700
          Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 15:26 -0400
  Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 18:24 +0200
    Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 19:57 +0200
      Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 11:23 -0700
        Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 20:25 +0200
          Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 11:39 -0700
            Re: Working from data converted from a pdf file Claus Busch <claus_busch@t-online.de> - 2016-04-06 20:53 +0200
              Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:17 -0700
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:27 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 15:39 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:46 -0700
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 12:49 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 16:05 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 13:17 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 16:30 -0400
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 16:35 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 13:51 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:12 -0400
                Re: Working from data converted from a pdf file B Roberson <jbr7655@gmail.com> - 2016-04-06 14:32 -0700
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:38 -0400
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:24 -0400
                Re: Working from data converted from a pdf file GS <gs@v.invalid> - 2016-04-06 17:35 -0400

csiph-web