[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Eliminate PCL from SQR output

Subject: Re: Eliminate PCL from SQR output
From: Ray Ontko <rayo@ONTKO.COM>
Date: Mon, 3 Jun 2002 16:14:24 -0500
In-reply-to: <200206032102.QAA02548@shire.ontko.com> from Ray Ontko at "Jun 3, 2002 04:02:12 pm"

Umm.  That would be BEFORE-BOLD or AFTER-BOLD,
not BEFORE_BOLD or AFTER_BOLD.

Ray

> Morgan,
>
> Look for the setupXX.sqc that would contain BEFORE_BOLD= or
> AFTER_BOLD= in a DECLARE PRINTER or DECLARE-PRINTER.
> If you can eliminate these options from the DECLARE
> commands, then you should be able to get clean output
> with -printer:lp.  You may want to create a separate
> directory for the .sqc files and use the -I flag to
> specify the order in which directories are searched for
> the include files.
>
> Hope this helps.
>
> Ray
>
> > Ray,
> >
> > Here is a cut/paste of just the headings from one of the reports in 
>question:
> >
> > 1BLocation: 0B  1BMedical College of Georgia0B
> > 1BDepartment:0B 1BAcademic & Std Affairs Admin0B   1B401000000B
> >
> >                                                   1BPlan0B   1BBenefit0B   
>1BLast Date0B   1BHrs Carried0B  1BHrs Taken0B   1BCurr Hrs0B     1BYTD 
>Hours0B   1BYTD Hours0B   1BYTD Hours0B   1BBalance0B
> > 1B______Emplid0B       1B____Name0B
> >
> > The jumble before most if the column headings is from BOLD & UNDERLINE.
> >
> > This was generated with the -printer:lp parameter.
> >
> > Unforunately I'm using sqr 4.3.4 which is bundled with PeopleSoft so I 
>guess I don't have some of the "features" that your newer 6.2 version does.
> >
> > Maybe I could just get you to run the reports for me on a weekly basis.  :-)
> >
> > Thx,
> > Morgan
> >
> >
> > >>> Ray Ontko <rayo@ontko.com> 06/03/2002 4:07:26 PM >>>
> > Morgan,
> >
> > With -printer:lp, in my version of SQR (6.2), BOLD is ignored and
> > UNDERLINE is handled by printing underscores first and then backing
> > up using ^H, and then printing the text.  If this is the problem
> > that you're experiencing, you could write a program that reads
> > each character for the line and appends it to a string.  If the
> > character is a backspace, you would shorten the string by one.
> > When you get to the end of a line, you write it out.
> >
> > Ray
> >
> > > Ray,
> > >
> > > Yes we're in a PeopleSoft environment.
> > >
> > > I think maybe I misunderstood part of my problem.  Part of the issue is 
>coming about with formatting within the report output as a result of the 
>column heading formatting parameters BOLD & UNDERLINE.  I assumed these were 
>PCL as well.
> > >
> > > The PCL at the top of the report is really not a big deal to skip; the 
>formatting characters embedded in the column headings and other places within 
>the report are, though.
> > >
> > > I've experimented with the -printer:lp and as from what I've seen so far 
>it doesn't take care of the column heading formatting.
> > >
> > > FYI - were running on Microsoft WinNT.
> > >
> > > Thanks,
> > > Morgan
> > >
> > > >>> rayo@ONTKO.COM 06/03/2002 3:17:10 PM >>>
> > > Morgan,
> > >
> > > Are you in a peoplesoft environment?  If so, then you are correct;
> > > it would require modification of the programs to choose a different
> > > printer type.  Richard was talking about using -printer:lp instead
> > > of -printer:hp when you run the report, which is easy to do if you're
> > > not using peoplesoft.
> > >
> > > If you are using peoplesoft, then you might be able to use a unix
> > > tool like "tail" which returns the end of a file.  If you know
> > > how long the PCL prefix is, you can get the end starting after
> > > the first 'n' bytes.  You could also use a little SQR program to
> > > do the same thing.
> > >
> > > What operating system are you using?
> > >
> > > Hope this helps.
> > >
> > > Ray
> > >
> > > > Thanks Richard - I realize that would take care of the issue.
> > > >
> > > > Problem is I don't want to have to go & change 30 vanilla reports to 
>eliminate the PCL.  I was hoping someone could think of a way to remove the 
>PCL after the fact or simply via a SQR command line parameter.
> > > >
> > > > Morgan
> > > >
> > > >
> > > >
> > > > >>> KnappR@UMSYSTEM.EDU 06/03/2002 2:40:18 PM >>>
> > > > The PCL is created when you declare your printer with a type to = HP.  
>Remove this from the code and all will be text.
> > > >
> > > > Richard
> > > >
> > > > -----Original Message-----
> > > > From: Morgan Whaley [mailto:MWHALEY@MAIL.MCG.EDU]
> > > > Sent: Monday, June 03, 2002 12:58 PM
> > > > To: SQR-USERS@list.iex.net
> > > > Subject: Eliminate PCL from SQR output
> > > >
> > > >
> > > > Does anyone know of a simple way to remove PCL from a .lis file without 
>having to physically change the associated SQR?  Is there a sqr command line 
>option that will take care of this?
> > > >
> > > > Basically what I need is for all of the PCL removed so that the 
>resulting output can be sent as plain ascii text to our document imaging 
>system.
> > > >
> > > > I've tried running the SQR with many various output formats.  The only 
>way I've been successfully as of yet is to send the sqr report output to HTML, 
>open in IE & then save as .txt.  Obviously, though, this isn't very efficient 
>when dealing with 20 - 30 reports a week.
> > > >
> > > > My environment info is: SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 
>1999
> > > >
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > TIA,
> > > >
> > > >
> > > > ----------------------------------------------------------
> > > > Morgan Whaley
> > > > Internet/CS Developer
> > > > Medical College of Georgia
> > > > Voice - 706.721.7291
> > > > Fax     - 706.721.6292
> > > > E-Mail - mwhaley@mail.mcg.edu
> > > > ----------------------------------------------------------
> > > >
> > >
> > > ----------------------------------------------------------------------
> > > Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> > > Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
> >
> > ----------------------------------------------------------------------
> > Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> > Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>
> ----------------------------------------------------------------------
> Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

References:
- Re: Eliminate PCL from SQR output
  - From: Ray Ontko <rayo@ONTKO.COM>

Prev by Date: Re: Eliminate PCL from SQR output
Next by Date: reading SQR parameters / command line flags
Previous by thread: Re: Eliminate PCL from SQR output
Next by thread: reading SQR parameters / command line flags
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page