messy text file-- how to automate import?

  • Thread starter Thread starter new_user
  • Start date Start date
N

new_user

I have a situation where I am getting reports (RTF
format) on a regular basis. These reports are formatted
in such a way that I have not been able to find a way to
convert them into delimited files and maintain the
integrity of the data.

I know this sounds odd, but they are formatted with
labels for the data running both horizontally and
vertically, use of columns is not consistent.

Each report is one page and they are identical in
format. From each report I need only two items, the
account name and a number all the other data on the page
is trash as far as I am concerned.

There are many reports, each a page in the same RTF
file. I have been pulling my hair out trying to find a
way to automate the extraction of this simple data.

I have tried everything I can think of to no avail.

Any ideas out there?

TIA,

Yum
 
I have a situation where I am getting reports (RTF
format) on a regular basis. These reports are formatted
in such a way that I have not been able to find a way to
convert them into delimited files and maintain the
integrity of the data.

I know this sounds odd, but they are formatted with
labels for the data running both horizontally and
vertically, use of columns is not consistent.

Each report is one page and they are identical in
format. From each report I need only two items, the
account name and a number all the other data on the page
is trash as far as I am concerned.

There are many reports, each a page in the same RTF
file. I have been pulling my hair out trying to find a
way to automate the extraction of this simple data.

I have tried everything I can think of to no avail.

Any ideas out there?

TIA,

Yum
Click to expand...

If the reports are truly consistant, it's pretty easy to import them
into Word and then run a macro to extract just the information that
you need. It may be possible to do the macro in excel, but I'm more
familiar with VBA in Word and have done similar extractions for
several different documents.
 
Back
Top