Put in quotes and commas to create a CSV file is your best bet. Then open in excel and save as an excel format. "field one ","field two ",123456789.12,"field three" Probably would be better to even put quotes around the number fields.
On Tue, Sep 3, 2019 at 1:13 AM Peter <[email protected]> wrote: > > Hi Group > > I have been using txt2pdf for a long and I understand it also does building > CSV files which can be opened using Excel. Is there a way to convert a text > file into Excel automatically within mainframe as > .XLS prior sending to email server ? > > Peter > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
