MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2005

Re: String and field delimeters when doing a CPYTOIMPF



fixed

I have given up on trying to use comma delimited files in favor of tab delimited
files to eliminate this issue completely.  Any pgm that can take a csv can
usually take a tab delimited.

I wrote a Perl utility to replace tabs with any delimited char if anyone wants
it.

Jerry

Quoting Martin Rowe <dbg400.net@xxxxxxxxx>:

> On 14/06/05, Malchow, Grizzly <GMalchow@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > I'm doing the following:
> > 
> > CPYTOIMPF FROMFILE(GRIZLIB/ALLSCRAP) TOSTMF('\TEMPFIL.CSV')
> > STMFCODPAG(*PCASCII) RCDDLM(*CRLF) STRDLM('"') FLDDLM(',')
> > 
> > The copy works fine except when the information in the "from file"
> > contains quotation marks or commas, which happens quite often. Is there
> > anyway to ignore the delimiter values when they are found in the "from
> > file"?
> 
> I don't know if it's of any help, but my CRTCSVDTA gives you the
> option of replacing STRDLM & FLDDLM values found in the field values
> with your choice of safe character. I tend to use ` and . in place of
> " and ,
> 
> Details and source code download from http://dbg400.net/crtcsv.html
> 
> Regards, Martin
> -- 
> martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
> DBG/400 - AS/400 & iSeries Open Source/Free Software utilities     \ /
> Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news   X
>                                                                    / \
> 
> -- 
> 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.
> 
> 







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact