Subject: | |
From: | |
Reply To: | COLE,GLENN (Non-HP-SantaClara,ex2) |
Date: | Fri, 23 Feb 2001 14:26:44 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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
|
|
|