FW: Stripping off CR codes

Pat Shugart ShugartP@trinity-health.org
Tue, 15 Jul 2003 13:21:45 -0400


Anthony,

If memory serves, you're running PH on an hp3k, right?

If so, try this:  tr -d "\015" < infile > outfile from the POSIX shell.
Where \015 is the Octal representation of a carriage return. It should
delete the CR from the file.

This is from memory and I haven't tried it, so you may want to check
the MAN page for tr just to be sure I have the syntax right.

HTH,


                                       ,,,,,
                                     ( o o )
=============oOO=======OOo================
Pat Shugart
Trinity Information Services
34605 Twelve Mile Road
Farmington Hills, MI 48331
248.489.6123
248.488.9195 (fax)

>>> "Arnone, Anthony" <aarnone@grey.com> 07/15/03 12:53PM >>>
I tried to create a subfile, and a subfile with format 0 but when I
transfered both files and open them in a hexEditor it still contains
the CR
codes. Does anyone know of a tool outside of Powerhouse that can strip
off
the CR codes or something in quiz that will suppress the codes.

Anthony

>  -----Original Message-----
> From: 	Arnone, Anthony  
> Sent:	Monday, July 14, 2003 4:17 PM
> To:	Powerhouse List (E-mail)
> Subject:	Stripping off CR codes
> 
> I am creating a file using the disc option in quiz that needs to be
> uploaded to an SAP system. The problem is that the SAP system is
rejecting
> the file because of the carriage return codes at the end of each
line. Is
> there a way that I can strip these off either in Quiz or with some
other
> tool. I am running ver 8.19 on MPE/iX. Below is the code that I am
using:
> 
> DEF T-DELIM CHA*1 = "|"
> DEF N-INV-D CHA*8 = ASC(INVOICE-DATE,8)[7:2] + &
>     ASC(INVOICE-DATE,8)[5:2] + ASC(INVOICE-DATE,8)[1:4]
> DEF N-TOT-AMT CHA*12 = &
>     PACK(ASC(TOT-INV-AMT/100) + "." + ASC(TOT-INV-AMT,12)[11:2])
> DEF N-LINE-AMT CHA*12 = &
>     PACK(ASC(LINE-ITEM-AMT/100) + "." + ASC(LINE-ITEM-AMT,12)[11:2])
> 
> DEF HFILE CHA*132 = PACK(TRU(HTYPE) + T-DELIM + TRU(N-INV-D)         
&
>  + T-DELIM + TRU(LEGAL-ENTITY) + T-DELIM + "USD" + T-DELIM + T-DELIM 
&
>  + "20517562" + T-DELIM + T-DELIM + TRU(INVOICE-NUMBER) + T-DELIM    
&
>  + TRU(HTEXT) + T-DELIM + TRU(N-TOT-AMT) + T-DELIM                   
&
>  + TRU(PYMT-TYPE) + T-DELIM + TRU(ASC(TOT-LINE-ITEMS)))
> DEF DFILE CHA*132 = PACK(TRU(DTYPE) + T-DELIM                        
&
>  + TRU(ASC(LINE-NUMBER)) + T-DELIM + TRU(ACCT-NUMBER) + T-DELIM      
&
>  + TRU(DTEXT) + T-DELIM + T-DELIM + TRU(N-LINE-AMT) + T-DELIM        
&
>  + "1Z" + T-DELIM + T-DELIM + T-DELIM + TRU(INTER-ORD-NUM)           
&
>  + T-DELIM + TRU(PO-NUMBER) + T-DELIM + TRU(ASC(PO-LINE-ITEM)))
> 
> HEA AT INVOICE-NUMBER TAB 1 HFILE
> REP TAB 1 DFILE
> 
> SET NOHEAD
> SET NOFORMFEED
> SET PAG WID 240
> SET PAG LEN 1
> SET REP DEV DISC NAME BILLING
> SET REP LIM 10000
> GO
> 
> R/S 
> Anthony Arnone 
> Programmer/Analyst 
> Grey Global Group 
> (212) 886-7812 
> aarnone@grey.com 
> 
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu 
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu 
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu 
http://lists.swau.edu/mailman/listinfo/powerh-l 
This list is closed, thus to post to the list you must be a
subscriber.