Putting TABS in SUBFILES

Pickering, John (NORBORD) PICKERIJ@norbord.com
Wed, 8 Aug 2001 15:45:31 -0400


Scott

An item defined as INT*9 is a double word integer. Your assignment to a
single character item will take the first byte of the string expression
CHAR(xxx) which will be binary zeroes on an HP 3000.

How about:
define d-09 int*2 = 9 ; use a single word integer
define d-tab char*1 = char(d-09)[2:1] ; take the rightmost byte

Regards,
JWP


> -----Original Message-----
> From:	Scott Gates [SMTP:SGates@OLBH.COM]
> Sent:	Wednesday, August 08, 2001 3:12 PM
> To:	OPOWERH-L@LISTSERV.UNB.CA
> Subject:	Putting TABS in SUBFILES
> 
> Simple question.  Most of you could do it in your sleep, I'd bet.
> 
> I'm creating a subfile to be imported into Excel.  I want to use tabs to
> delimit the fields.  But when I transfer using Reflections, All my tabs
> are
> converted to 00 (null) characters.
> 
> I'm sure I'm doing something wrong either with the Define.
> I've printed with DISPLAY FUNCTIONS and don't see the tabs either.
> Here's a piece of my code.
> 
> acc *FEDTXRPA
> 
> DEF NTAB INT*9 = 9
> DEF HTAB CHAR*1 = CHAR(NTAB)
> 
> SORT ON EMP-NBR
> SET SUB NAME FEDTXRPD AT EMP-NBR SIZE 20000 KEEP
> REP  SUM     &
>          ENTITY-ID        HTAB      &
>          CALENDAR-YEAR    HTAB      &
>          Q
> :yadda :
> :yadda :
> 
> Go
> 
> 
> 
> Scott Gates
> Programmer/Analyst
> Information Services
> Our Lady of Bellefonte Hospital
> P.O. Box 789
> Ashland, Kentucky 41105-0789
> -----------------------------------
> Phone: (606)833-3773
>   Fax: (606)833-3342
> -----------------------------------
> Intranet: http://Olbh01iis/intranet/index.html
> Primary e-mail  : [mailto:sgates@olbh.com]
> Alternate e-mail : [mailto:msgates@pobox.com]
> -----------------------------------
> Our Lady of Bellefonte : http://www.olbh.com
>