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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.