|
Don I should have said x'05' for the tab - that's the EBCDIC value and usually converts directly to x'09' ASCII. Use *CR or *LF for record indicator. With Excel 2002 it opened up the dialog for parsing the columns. Maybe there's a default setting or filter for this? > Now that sounds quite promising, especially since it would allow me to use > the AS/400 to send the file via email. I attempted this suggestion but the > file looked like garbage when opened by Excel. Some research in the > archives revealed that PTF SF62142 is probably needed so the EBCDIC will be > converted to ASCII by CPYTOIMPF. > > I'll let you know if this works after we get the PTF installed. > > Donald R. Fisher, III > Project Manager > The Roomstore Furniture Company > (804) 784-7600 extension 2124 > DFisher@roomstoreeast.com > > <clip> > One more idea - the delimiter for cells is hex09, right? > And for rows it's hex13? You can name both of these in > the CPYTOIMPF. This should open directly in Excel. > <clip>
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.
midrange.com
