Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
messy text file-- how to automate import?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
Automate text import wizard in a protected sheet | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
Messy Text to Columns | Excel Discussion (Misc queries) | |||
Automate the Text Import Wizard (Fixed Width) | Excel Worksheet Functions |