Re: Converting Text to XLS

2010-04-22 Thread Pete Borton
. 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

Recall: Converting Text to XLS

2010-04-22 Thread Pete Borton
Peter Borton would like to recall the message, Converting Text to XLS.

Re: Converting Text to XLS

2010-04-21 Thread Pete 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 a text file on CMS? The file can

Re: Converting Text to XLS

2010-04-21 Thread Frank M. Ramaekers
, 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

Re: Converting Text to XLS

2010-04-21 Thread Dave Jones
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

Re: Converting Text to XLS

2010-04-21 Thread David Boyes
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

Re: Converting Text to XLS

2010-04-21 Thread Fran Hensler
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

Re: Converting Text to XLS

2010-04-21 Thread Alan Winson
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

Re: Converting Text to XLS

2010-04-21 Thread Schuh, Richard
: 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

Re: Converting Text to XLS

2010-04-21 Thread Schuh, Richard
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

Converting Text to XLS

2010-04-20 Thread Schuh, Richard
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

Re: Converting Text to XLS

2010-04-20 Thread Wandschneider, Scott
@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

Re: Converting Text to XLS

2010-04-20 Thread Stace Cameron
Another possibility is the symbolic link format file (SYLK). .

Re: Converting Text to XLS

2010-04-20 Thread Schuh, Richard
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

Re: Converting Text to XLS

2010-04-20 Thread Schuh, Richard
@LISTSERV.UARK.EDU Subject: Re: Converting Text to XLS Another possibility is the symbolic link format file (SYLK). .

Re: Converting Text to XLS

2010-04-20 Thread Schuh, Richard
, 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

Re: Converting Text to XLS

2010-04-20 Thread Schuh, Richard
@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

Re: Converting Text to XLS

2010-04-20 Thread Peter . Webb
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

Re: Converting Text to XLS

2010-04-20 Thread Les Koehler
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

Re: Converting Text to XLS

2010-04-20 Thread Frank M. Ramaekers
@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

Re: Converting Text to XLS

2010-04-20 Thread Schuh, Richard
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

Re: Converting Text to XLS

2010-04-20 Thread A. Harry Williams
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

Re: Converting Text to XLS

2010-04-20 Thread Lionel Dyck
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

Re: Converting Text to XLS

2010-04-20 Thread Schuh, Richard
...@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

Re: Converting Text to XLS

2010-04-20 Thread Dave Wade
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

Re: Converting Text to XLS

2010-04-20 Thread Fran Hensler
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