|
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 -- martin@dbg400.net / jamaro@firstlinux.net 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.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.