Create a text file comma delimited with " around each field.

From: "Lauritzen, Karl" 
To: "'midrange-l@midrange.com'" 
Subject: RE: AS/400 app FTPs file to IFS???
Date: Wed, 6 Nov 2002 08:29:13 -0600 
Reply-To: midrange-l@midrange.com

Try this

CPYTOSTMF  +
             FROMMBR('/qsys.lib/yourlib.lib/yoursrc.file/yourfile.file +

             TOSTMF('/IFS/downloadedfilename.txt') +
             STMFOPT(*REPLACE) STMFCODPAG(*PCASCII)
CPYTOIMPF  FROMFILE(yourlib/yourfile) +
             TOSTMF('/IFS/downloadedfilename.txt') +
             MBROPT(*REPLACE) RCDDLM(*CRLF) FLDDLM(X'05')

Creates a text file comma delimited with " around each field.
You can then import this file into Excel or wherever.

I had a hard time at first too with this but now I use it all the time.

[report a broken link by clicking here]