RE: CPYTOPCD Translation Tables

[vhamberg@xxxxxxxxx]

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>