Re: String and field delimeters when doing a CPYTOIMPF

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