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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
messy text file-- how to automate import?
Hi,
Can you email me a sample of the file, maybe I can come up with something. ) zantor ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
messy text file-- how to automate import?
Thanks! Will do.
-----Original Message----- Hi, Can you email me a sample of the file, maybe I can come up with something. ) zantor ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
messy text file-- how to automate import?
On Mon, 15 Sep 2003 20:22:39 -0700, "new_user"
wrote: 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 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. -- Charlie Hoffpauir http://freepages.genealogy.rootsweb.com/~charlieh/ If you really want to reply via email, my valid address is available on my web site. |
Reply |
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 |