Subject: | |
From: | |
Reply To: | |
Date: | Wed, 4 Nov 2015 15:52:27 -0800 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
There seem to be at least two steps to what you are trying to do.
1) Remove the headers, footers and perhaps page numbers from the report.
2) Remove the ff or CNTL characters from the text file.
3) Import a space delimited file to Excel.
There are any number of different scripting tools that can do this including various UNIX tools. Here's a reference to Excel solution that might get you started. In fact, if it were my problem to solve, I would likely do it all with Excel scripting.
http://www.mrexcel.com/forum/excel-questions/680923-removing-multiple-headers-imported-text-file.html
We've done similar things over the years and I'm afraid Tracy is correct in his assessment that this is a specific problem that requires a certain amount of custom effort to achieve. If you don't have time to learn the scripting skills that are needed you may need to pay someone to do it for you.
Charles Finley
(619) 795-0720
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Tim O'Neill
Sent: Wednesday, November 04, 2015 1:45 PM
To: [log in to unmask]
Subject: Re: Mpe: From Spool File to Excel
Thank you.
The header (repeated every time there was either a "page eject" or "form feed") was created by the Editor (TDP) which went as follows:
-Top of page
-Header
-Lines of report until end of page
-Top of page
-Header
-Lines of report until end of page
However Editor apparently counted lines, because when I print with smaller font size (thus higher pitch,) it leaves a lot of white space at the bottom of each printed page.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|