.
Regards,
Peter Borton
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: 20 April 2010 18:27
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS
Does anyone know of a program to create an XLS file from
Peter Borton would like to recall the message, Converting Text to XLS.
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: 20 April 2010 18:27
To: IBMVM@LISTSERV.UARK.EDU
Subject: Converting Text to XLS
Does anyone know of a program to create an XLS file from a text file on
CMS? The file can
, Richard
Sent: Tuesday, April 20, 2010 4:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I want them to have a consistent view when it is received. I don't give
a damn what they do with it afterward.
Regards,
Richard Schuh
Richard, I think the easiest thing to do now is simply upgrade your
users...
On 04/21/2010 10:33 AM, Schuh, Richard wrote:
I often send CSV files with a .txt extension. I use a TAB
X'05' as a delimiter which is the default for for .txt files.
That is what I have been providing for
That is what I have been providing for them. It makes no difference
whether the file is banana.txt or banana.csv, it will be opened
properly by Excel.
As much as I dislike dealing with XML in general, the XML suggestion is
probably the best one so far. That would let you generate both data
I think you might have a solution there. A canned email or even an
attachment with instructions.
/Fran
On Wed, 21 Apr 2010 08:33:54 -0700 Schuh, Richard said:
the files themselves, so I get complaints. If I do not find a
Richard, just yesterday I finished working on a REXX program that generat
es
CSV, HTML, or XML for a simple spreadsheet. If you're interested, I can
ask
my employer whether I can give it to you.
You'd have to cannibalize it, since it does not read a text file; it
generates its own data by
: Converting Text to XLS
Richard, I think the easiest thing to do now is simply
upgrade your users...
On 04/21/2010 10:33 AM, Schuh, Richard wrote:
I often send CSV files with a .txt extension. I use a TAB
X'05' as a
delimiter which is the default for for .txt files
Of Alan Winson
Sent: Wednesday, April 21, 2010 8:59 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
Richard, just yesterday I finished working on a REXX program
that generat= es CSV, HTML, or XML for a simple spreadsheet.
If you're interested, I can = ask my employer whether
Does anyone know of a program to create an XLS file from a text file on CMS?
The file can be sent as a CSV file attached to an e-mail; however, opening the
CSV file with Excel or other spreadsheet programs exposes a few formatting
problems/inconsistencies that must be fixed by manual
@LISTSERV.UARK.EDU
Subject: Converting Text to XLS
Does anyone know of a program to create an XLS file from a text file on
CMS? The file can be sent as a CSV file attached to an e-mail; however,
opening the CSV file with Excel or other spreadsheet programs exposes a
few formatting problems/inconsistencies
Another possibility is the symbolic link format file (SYLK).
.
of the doubt) have messed up.
Regards,
Richard Schuh
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf
Of Wandschneider, Scott
Sent: Tuesday, April 20, 2010 10:40 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I
@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
Another possibility is the symbolic link format file (SYLK).
.
, April 20, 2010 11:27 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
Richard,
I've a dumb question to ask - why does the CMS file have to
be opened by a spreadsheet program?
On Tue, Apr 20, 2010 at 12:19 PM, Schuh, Richard
rsc...@visa.com wrote:
Right now, I am
@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
What languages do you have available? If you have a current Java, then I'd
suggest looking at Apache:POI
http://poi.apache.org/
John McKown
Systems Engineer IV
IT
Administrative Services Group
HealthMarkets(r)
9151 Boulevard 26 * N. Richland Hills * TX
work.
Peter
-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: April 20, 2010 14:22
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
Are there programs to do that conversion in CMS? I am
You could use OORexx and its support for OLE to
automatically fix the inconsistencies.
Les
Schuh, Richard wrote:
Does anyone know of a program to create an XLS file from a text file on CMS?
The file can be sent as a CSV file attached to an e-mail; however, opening the
CSV file with Excel or
@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
Right now, I am creating a csv file using tab (x'05', which is also the
default field separator in Pipelines) characters as a separator. Since I
do not have control of the width of cells, I need to be able to
selectively specify whether to align right
20, 2010 12:28 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
...and you don't want to have to futz with Excel macros or scripts?
Frank M. Ramaekers Jr.
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf
On Tue, 20 Apr 2010 10:27:09 -0700 Schuh, Richard said:
Does anyone know of a program to create an XLS file from a text file on CMS?
The
file can be sent as a CSV file attached to an e-mail; however, opening the CSV
file with Excel or other spreadsheet programs exposes a few formatting
From: Schuh, Richard rsc...@visa.com
To: IBMVM@LISTSERV.UARK.EDU
Date: 04/20/2010 02:28 PM
Subject:Re: Converting Text to XLS
Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU
I want them to have a consistent view when it is received. I don't give
...@listserv.uark.edu] On Behalf
Of Lionel Dyck
Sent: Tuesday, April 20, 2010 2:38 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I've done some work with text to csv for z/os and never found a way to get the
csv to open in a decent view in excel as a csv is the lowest common format
Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: 20 April 2010 22:27
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: Converting Text to XLS
I want them to have a consistent view when it is received. I don't give a
damn what they do
Richard -
I often send CSV files with a .txt extension. I use a TAB X'05' as a
delimiter which is the default for for .txt files.
The files are sent to user's network drive. They start Excel, OPEN
the file and Excel recognizes the TAB delimiters and automatically
pulls the file into the
26 matches
Mail list logo