Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108721
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Working from data converted from a pdf file |
| Date | 2016-04-06 15:26 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <ne3nnj$ued$1@dont-email.me> (permalink) |
| References | <1d84b4a6-d989-421f-bce4-7ac223f5bcae@googlegroups.com> <ne3csm$ibf$1@dont-email.me> <5ddfe2c2-9cdf-4ff7-934a-d032c9011047@googlegroups.com> <ne3mik$pqu$1@dont-email.me> <8c57a9d8-c1b9-4210-923b-ddeb8787b6db@googlegroups.com> |
> > >> Ok, thanks! This tells me what was used as the col delimiter. While >> your sample data 'appears' tab delimited, it's better to be sure. Of >> course, this means nothing if the data is already imported into the >> worksheet. It means a lot if the data is stored in a text file >> rather than PDF because that way it can be read into an array, >> parsed as desired, then 'dumped' into a worksheet; -all quite >> easily. That means the file that your PDF was created from might be >> a better source if available!!! >> >> Meanwhile, I'll also take a look at your sample file as your data >> layout is similar to how my menu-builder routine reads in its data. >> In this case working code for this already exists and just needs >> tweaking to suit your usage! >> >> -- >> Garry > Garry and Claus, here is my link. > https://www.dropbox.com/s/aguedei0jqymk4p/Check%20Detail%20March%2031%2C%202016.xlsm?dl=0 > > Sheet1 contains all the data that nuance parsed just the way it > parsed it, pretty messed up but then it looks like the check stub > does. > > On sheet2, I just put in 4 records so you could see where I was > getting the information starting at the top of sheet1. > > I also included the total of the check at the bottom of sheet2 as it > appears on the sheet1. What makes this really messy is that it has 92 > pages in here of pdf data it had been printed out as shown. That is a > lot of mess to process manually, so that is why I am trying to help > out an accountant in our office by tabling it so it can be mapped > into where it needs to go. > > Bruce Who creates the PDF? Can you inquire if the data is available as a text file? -- 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 | Next — Previous in thread | Next in thread | Find similar | Unroll 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