AS/400-to-Excel downloading

[Chris Sharman]

> Is this unique to the AS/400?

No - I'm on VMS myself - it relies only on Excel's treatment of embedded cr.
My suggestion was for quoted data, sorry.
The skip needs to go inside quotes, regardless of whether your other data is
quoted.
Eg.
define d_lim char*1 = ","
define d_25 char*25 = "XXXXXXXXXXXXXXXXXXXXXXXXX"
rep ... d_lim d25 ',"' skip '",' d25 d_lim ...

Sorry if I wasn't clear.

Chris

> I've tried to reproduce this in a VMS environment.  I'm reporting
> on 15 rows
> and producing 30 lines in my .txt file from Quiz.  When I pull
> the file into
> Excel, it remains 30 rows.  The wrapped reporting lines are not be joined
> together.
>
> My test looks something like this:
>
> access test_table
>
> define d_25 char*25 = "XXXXXXXXXXXXXXXXXXXXXXXXX"
>
> define d_lim char*1 = ","
>
> report  &
> test_field_1             d_lim   & ; char*1
> test_field_2        d_lim   &	; char*30
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> '","' skip '","' d_25           d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25            d_lim   &
> d_25
>
> set rep dev disc name test_skip_rpt0 spacing 0
> set page length 0 width 255
> set nohead
> set noformfeed
>
> I'm wondering if I mis-interpreted your post, or if the file generated in
> VMS is different from the AS/400.
>



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.