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.