ChandlerW
12-20-2012, 07:28 PM
Greeting all,
I am working with a software program that was written in 1995. The program generates a report and formats the report on 3 lines.
I do not have an option of changing the report output.
I am able to email the report and it is attached as a text file.
What I would like to do is import the text file into excel and then generate a pivot table based on the data in the report.
The pivot table is not working for me since I need columns with specific names. I'm thinking if I am able to clean up the output and stick it on one line, then import the data it will be cleaner.
My thoughts are to read one line, stick it in a string, read the next line, stick that in another string, read the third line, and put all three strings in a string variable and write it out to a text file.
Then I can import that text file into excel, insert my pivot table and go from there.
What do you all think? Is there an easier way to do what I need?
I am working with a software program that was written in 1995. The program generates a report and formats the report on 3 lines.
I do not have an option of changing the report output.
I am able to email the report and it is attached as a text file.
What I would like to do is import the text file into excel and then generate a pivot table based on the data in the report.
The pivot table is not working for me since I need columns with specific names. I'm thinking if I am able to clean up the output and stick it on one line, then import the data it will be cleaner.
My thoughts are to read one line, stick it in a string, read the next line, stick that in another string, read the third line, and put all three strings in a string variable and write it out to a text file.
Then I can import that text file into excel, insert my pivot table and go from there.
What do you all think? Is there an easier way to do what I need?