RE: Using cpytoimpf to create a tab delimited file on the IFS

[Martin Rowe <martin@xxxxxxxxxx>]

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.