HP3000-L Archives

February 2001, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"COLE,GLENN (Non-HP-SantaClara,ex2)" <[log in to unmask]>
Reply To:
COLE,GLENN (Non-HP-SantaClara,ex2)
Date:
Fri, 23 Feb 2001 14:26:44 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (33 lines)
Jack Gaddy wrote originally:

> We're trying to use QUIZ to produce a TAB-delimited Flat-file
> to export to a PC-based Sales Inquiry Tool.

then with the solution:

> Thanks to John Pickering [[log in to unmask]] for a Great
> suggestion - it worked!  he wrote,
>
> Define the tab character as below and then include it between
> each field that you're reporting. ...
> >DEFINE D-09 INT*2 = 09
> >DEFINE D-TAB CHAR*1 = CHAR(D-09)[2:1]
> >REPORT &
> > ITEM1 D-TAB ITEM2 D-TAB

I'm glad this works for you, but there is at least one thing
to keep in mind if you try to use this as a general solution.

Unless you explicitly truncate() each string field, importing
the resulting file into Excel causes the fields to retain trailing
blanks, which can be a pain.

Personally, I much prefer using Suprtool's STExport module
for such tasks.  Performing such reformatting is its reason
for existing.  The only real downside is having to specify
the layout a second time (the first time in PowerHouse, and
the second in Suprtool).  Just be aware that the file created
by STExport needs to be XLTrim'd, for which I use MPEX.

--Glenn

ATOM RSS1 RSS2