PDF Table to Excel Spreadsheet

This has been asked in numerous places all over the web but I have not
found a workable solution. We have a mainframe system that generates
PDF reports for billing. However, few people in our organization
these days speak mainframe. We need Excel to do calculations on the
data. I began working on a method for converting using UEdit Macros
and an Excel macro because the fields are fixed-width. My attempts
have been unsuccessful.

Here is what I want to accomplish:
-Copy a region of text from a PDF
-Paste into Excel
-Break the values out into the appropriate cells.

Bob
Tue Jun 03 12:55:03 CDT 2008

http://www.google.com/search?hl=en&q=pdf+converter&btnG=Google+Search

seven_percent wrote:

> This has been asked in numerous places all over the web but I have not
> found a workable solution. We have a mainframe system that generates
> PDF reports for billing. However, few people in our organization
> these days speak mainframe. We need Excel to do calculations on the
> data. I began working on a method for converting using UEdit Macros
> and an Excel macro because the fields are fixed-width. My attempts
> have been unsuccessful.
>
> Here is what I want to accomplish:
> -Copy a region of text from a PDF
> -Paste into Excel
> -Break the values out into the appropriate cells.

seven_percent
Wed Jun 04 07:19:14 CDT 2008

On Jun 3, 1:55=A0pm, Bob I <bire...@yahoo.com> wrote:
> http://www.google.com/search?hl=3Den&q=3Dpdf+converter&btnG=3DGoogle+Searc=
h
>
>
>
> seven_percent wrote:
> > This has been asked in numerous places all over the web but I have not
> > found a workable solution. =A0We have a mainframe system that generates
> > PDF reports for billing. =A0However, few people in our organization
> > these days speak mainframe. =A0We need Excel to do calculations on the
> > data. =A0I began working on a method for converting using UEdit Macros
> > and an Excel macro because the fields are fixed-width. My attempts
> > have been unsuccessful.
>
> > Here is what I want to accomplish:
> > -Copy a region of text from a PDF
> > -Paste into Excel
> > -Break the values out into the appropriate cells.- Hide quoted text -
>
> - Show quoted text -

Thanks. I tried several last night but they didn't do precisely what
I wanted. Do you know of any that allow you to define field lengths
for dissecting the info in the PDF? E.g. first convert the data in
the file to a pure text format, then apply the field definitions?

Bob
Wed Jun 04 08:16:31 CDT 2008



seven_percent wrote:

> On Jun 3, 1:55 pm, Bob I <bire...@yahoo.com> wrote:
>
>>http://www.google.com/search?hl=en&q=pdf+converter&btnG=Google+Search
>>
>>
>>
>>seven_percent wrote:
>>
>>>This has been asked in numerous places all over the web but I have not
>>>found a workable solution. We have a mainframe system that generates
>>>PDF reports for billing. However, few people in our organization
>>>these days speak mainframe. We need Excel to do calculations on the
>>>data. I began working on a method for converting using UEdit Macros
>>>and an Excel macro because the fields are fixed-width. My attempts
>>>have been unsuccessful.
>>
>>>Here is what I want to accomplish:
>>>-Copy a region of text from a PDF
>>>-Paste into Excel
>>>-Break the values out into the appropriate cells.- Hide quoted text -
>>
>>- Show quoted text -
>
>
> Thanks. I tried several last night but they didn't do precisely what
> I wanted. Do you know of any that allow you to define field lengths
> for dissecting the info in the PDF? E.g. first convert the data in
> the file to a pure text format, then apply the field definitions?

Sorry, I hardly ever go from PDF to text, and so it's usually a print to
file and OCR it for anything I do.

seven_percent
Wed Jun 04 11:24:08 CDT 2008

On Jun 4, 9:16=A0am, Bob I <bire...@yahoo.com> wrote:
> seven_percent wrote:
> > On Jun 3, 1:55 pm, Bob I <bire...@yahoo.com> wrote:
>
> >>http://www.google.com/search?hl=3Den&q=3Dpdf+converter&btnG=3DGoogle+Sea=
rch
>
> >>seven_percent wrote:
>
> >>>This has been asked in numerous places all over the web but I have not
> >>>found a workable solution. =A0We have a mainframe system that generates=

> >>>PDF reports for billing. =A0However, few people in our organization
> >>>these days speak mainframe. =A0We need Excel to do calculations on the
> >>>data. =A0I began working on a method for converting using UEdit Macros
> >>>and an Excel macro because the fields are fixed-width. My attempts
> >>>have been unsuccessful.
>
> >>>Here is what I want to accomplish:
> >>>-Copy a region of text from a PDF
> >>>-Paste into Excel
> >>>-Break the values out into the appropriate cells.- Hide quoted text -
>
> >>- Show quoted text -
>
> > Thanks. =A0I tried several last night but they didn't do precisely what
> > I wanted. =A0Do you know of any that allow you to define field lengths
> > for dissecting the info in the PDF? =A0E.g. first convert the data in
> > the file to a pure text format, then apply the field definitions?
>
> Sorry, I hardly ever go from PDF to text, and so it's usually a print to
> file and OCR it for anything I do.- Hide quoted text -
>
> - Show quoted text -

Alright. Thanks again for taking the time to respond.