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