G
Guest
Hello everyone-
I am working at a company that uses a very old host system to run their
construction business. Until yesterday, nobody has ventured in capturing
reports to file, instead of printing them out. After 8 hours of actually
accessing the FTP remote thru DOS(!!!!!) I was able to get .txt files out of
system.
However, importing them into excel has been a big pain.
The reports do have a delimiter between the main columns (+), so the main
part of the report is seperated into the proper columns. However the header
information is a major problem. The delimiters do not match up with the
columns of the main part of the report, so I have to manually delete their
seperators, which leaves me with useless header information. Unfortunately
the header information repeats after each job, and the report has about 80
jobs on it. So there is a lot of useless information trapped in there that i
dont know what to do with.
Does anyone have any ideas for a solution??
Mariano
I am working at a company that uses a very old host system to run their
construction business. Until yesterday, nobody has ventured in capturing
reports to file, instead of printing them out. After 8 hours of actually
accessing the FTP remote thru DOS(!!!!!) I was able to get .txt files out of
system.
However, importing them into excel has been a big pain.
The reports do have a delimiter between the main columns (+), so the main
part of the report is seperated into the proper columns. However the header
information is a major problem. The delimiters do not match up with the
columns of the main part of the report, so I have to manually delete their
seperators, which leaves me with useless header information. Unfortunately
the header information repeats after each job, and the report has about 80
jobs on it. So there is a lot of useless information trapped in there that i
dont know what to do with.
Does anyone have any ideas for a solution??
Mariano