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
>