On Tue, 3 Sep 2019 01:30:59 -0500, Mike Schwab wrote: >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. > And you must defend against text fields which happen to contain quotes.
In any case, it depends on the specific format of the text file. There's no general solution. Several years ago, reacting to a wish I saw here, I wrote a filter to convert SMP/E Enhanced Holddata to .CSV. Still works. But, always, utterly dependent on input data format. It might provide an example. >On Tue, Sep 3, 2019 at 1:13 AM Peter wrote: >> >> 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 ? >> Must it be .XLS or is .CSV suitable? -- gil ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
