Hello Richard,
You are sending a email with attached CSV file correct?
Was the example I sent you not what was needed or am I missing something
(very normal thing)?
Ed Martin
Aultman Health Foundation
330-363-5050
ext 35050
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 5: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
________________________________
From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Frank M. Ramaekers
Sent: Tuesday, April 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 Of Schuh, Richard
Sent: Tuesday, April 20, 2010 1:19 PM
To: IBMVM@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 or left and top or
bottom in the cells of a column. I suppose I could use a multiple pass
process where I get the max size of a cell in each column and create
fixed size cells and align things myself. Then, there are such things as
table and column headings and anything else needed to make it print
friendly. Even then, the output would still be a text file. not xls.
The short of it is, I am trying to make it so that the recipient
does not have to futz with formats or headings when the file is opened
by Excel. I have seen some really strange formats when looking at files
that people (in ISO, but I will give them the benefit 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 create several text files on CMS where I use the > or
< character as a delimiter and surround special text with ".
Thank you,
Scott
From: The IBM z/VM Operating System
[mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard
Sent: Tuesday, April 20, 2010 12:27 PM
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 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 manipulation.
Regards,
Richard Schuh
Confidentiality Note: This e-mail, including any
attachment to it, may contain material that is confidential,
proprietary, privileged and/or "Protected Health Information," within
the meaning of the regulations under the Health Insurance Portability &
Accountability Act as amended. If it is not clear that you are the
intended recipient, you are hereby notified that you have received this
transmittal in error, and any review, dissemination, distribution or
copying of this e-mail, including any attachment to it, is strictly
prohibited. If you have received this e-mail in error, please
immediately return it to the sender and delete it from your system.
Thank you.
_____________________________________________________ This
message contains information which is privileged and confidential and is
solely for the use of the intended recipient. If you are not the
intended recipient, be aware that any review, disclosure, copying,
distribution, or use of the contents of this message is strictly
prohibited. If you have received this in error, please destroy it
immediately and notify us at privacy...@ailife.com.
