On Thu, 2002-01-03 at 13:25, Saunders, Martin P wrote: > I tried it using x'05' as the delimiter and that seems to work OK. That > command (cpytoimpf) could really use some kind of 'trim' option to get rid > of trailing spaces in fields. Hi Martin My CRTCSVDTA utility trims trailing spaces, so you could give that a try if CPYTOIMPF isn't up to the job ;-) Go to http://www.dbg400.net/crtcsv.html to read the details and grab the code. I use it in conjunction with CPYTOSTMF to get the data onto the IFS and with the right code page, and when I get some free time I'll upload a front end for it that combines the two (plus some other extras). Regards, Martin -- email@example.com / firstname.lastname@example.org http://www.dbg400.net DBG/400 - DataBase Generation utilities Open Source test environment tools for the AS/400 / iSeries and miscellaneous database & spooled file management commands.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.