× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On Wednesday 14 November 2001 5:04 pm, Goodbar, Loyd (AFS-Water Valley)
wrote:
[snip]
> I could manually dump the data, trim spaces, and add commas into a
> single field work file that I could then run through CPYTOSTMF. I would
> rather not do that,

Hi Loyd

Well, maybe I've saved you the bother ;-) My CRTCSVDTA tool does just
that, ready for CPYTOSTMF. Trailing spaces trimmed, dates in numeric
fields converted to proper dates and a few other formatting options.

> if OS400 has a command to correctly trim the
> character data when creating a CSV file. Well, it doesn't know it's a
> CSV file, but if you change the DTAFMT parameter to *DLM, it should be
> smart enough to trim the data (being the whole point of delimiting it).
> I understand that using DTAFMT(*FIXED) would preserve trailing spaces,
> and it should.
>
> Loyd

Agreed. Apart from the need to convert our own Lilian dates to something
spreadsheets could easily understand, trailing spaces was one of the main
things I wanted in a conversion tool - hence writing my own. Grab the
code at http://www.dbg400.net/crtcsv.html

Regards, Martin
--
martin@dbg400.net  jamaro@firstlinux.net  http://www.dbg400.net        /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \ /
Source free test environment tools and others (file/spool/misc)         X
[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  / \


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