.TXT file conversion to .CSV/.XLSX

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

.TXT file conversion to .CSV/.XLSX

Postby dangtran10 » Thu May 20, 2021 7:09 am

hi -

I have a batch job that produce an output file as HLQ1.DATA.TXT. it looks something like this:


And I want to send this file as excel to a customer. The current process is:

1. use reflection FTP to desktop and open the txt file in excel and adjust the columns accordingly (insert sheet rows with names, insert another row for the title).
2. then email them this file as excel.

So I’m trying to automate step #2/3 in a JCL as additional steps. Step #2 I can use a few utility to send. It’s Step #1 I’m trying to do in a job.
Posts: 2
Joined: Tue May 11, 2021 7:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: .TXT file conversion to .CSV/.XLSX

Postby sergeyken » Fri May 21, 2021 4:26 am

How DFSORT/ICETOOL/IEBGENER utilities may be used in your plans? Which step?

As of today, there is no mainframe utility which is able to produce any Excel file. Some “smart” programs can produce PDF files, but not Excel ones yet.
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
Posts: 401
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times

Re: .TXT file conversion to .CSV/.XLSX

Postby willy jensen » Fri May 21, 2021 1:42 pm

EXCEL can read CSV files, so why the need for a 'real' EXCEL format?
willy jensen
Posts: 450
Joined: Thu Mar 10, 2016 5:03 pm
Has thanked: 0 time
Been thanked: 68 times

Re: .TXT file conversion to .CSV/.XLSX

Postby steve-myers » Fri May 21, 2021 10:57 pm

18 or 19 years ago I had a mainframe program to process SMF data and produce reports. It occurred to me it would be useful for OpenOffice (this was before LibreOffice) to also get the data. It was not hard for the mainframe program to generate a CSV data set to send to the workstation for OpenOffic (or Excel) to process to generate some decent graphs. As Sergeyken says, it should not be difficult for DFSORT to create a CSV data set much like my program in 2002 or 2003 did.
Global moderator
Posts: 2106
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times



  • Related topics
    Last post