Re: Comma-delimited help

[rick baird <rick.baird@xxxxxxxxx>]

Martin,

Thanks!   i'm sure your solution is much more elegant than my kludge. 
It was a "gotta have it now" kind of thing, and I just put in a
"%check" for numbers and blanks, and if found and the string starts
with 0, prepended the quote.

I'll try to find time to download the latest soon.

Rick


On Mon, 28 Feb 2005 12:20:20 +0000, Martin Rowe <martin@xxxxxxxxxx> wrote:
> On Sat, 2005-02-26 at 10:30 -0500, rick baird wrote:
> > Andy,
> >
> > If none of these threads help you, you could give a freeware open
> > source utility a try - Martin Rowe has a utility called CRTCSVSTMF
> > that trims blanks from the resulting csv.
> >
> > Since v5r3, I've found it to be more stable and predictable than
> > CPYTOIMPF - especially with regard to code pages and CCSID.
> >
> > you can download at http://www.dbg400.net/
> >
> > The best part is you have the source and can tweek it.  In our system
> > we have several alpha fields with leading zeros, and when the csv is
> > opened in excel, it trims them.   I modified my version to look for
> > long numeric strings (  000000044394930384 for instance ) and if
> > found, it places a single quote at the beginning of the string.
> >
> > This keeps excel from trimming the leading zeros.
> 
> Rick
> 
> If you use the field mapping rules (EDTFLDMAP) in conjunction with
> CRTCSVSTMF, you can choose to set a field prefix of ' (or any other
> character) to character fields if you know they hold numeric data. I
> *thought* I'd uploaded this change some time back (added it summer '03)
> but it appears I hadn't - oops. Grab the latest version from
> http://www.dbg400.net/crtcsv.html
> 
> Regards, Martin
> --
> martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net       /"\
> DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \ /
> Source free test environment tools and others (file/spool/misc)         X
> [this space for hire]  ASCII Ribbon Campaign against HTML mail & news  / \
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>