|
Bill; Based on the examples you have given, it appears that you are getting exactly what you asked for, if not what you really wanted. Remember CSV files are just text, with commas inserted that Excel interperts as meaing go to the next column after each comma, but they are not true XLS files. Your value of '3. is what you have done to put a 3 concatenated directly after the lead '. That "label" is a feature of Excel, that is not fully supported in CSV files. If you take a regular XLS file and try to save it as a CSV file you will get an M$ warning message that some features are not supported by CSV files, You have found one of those unsupported features. Andy Leisk Senior Programmer Analyst Banta Global Turnkey 1457 Earl Street Menasha, WI 54952 ph: 920-751-4434 web: www.banta.com -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of bill.howie@xxxxxxxxxxxxxx Sent: Wednesday, August 03, 2005 7:46 AM To: midrange-l@xxxxxxxxxxxx Subject: CPYTOIMPF and the apostrophe Hello all...... I have what I hope is a simple question. I am using CPYTOIMPF to create a CSV file for an application I am working on. One of the fields I have in the ISeries file that I am copying is a numeric field that I convert to alpha with the %EDITC BIF. This field translates to the CSV file just fine. However, we have a need for an apostrophe to be right before the number in the cell in the CSV file that this field occupies. In Excel, this identifies the field as a label. I can do the CPYTOIMPF without attaching an apostrophe on that field, and then within the CSV sheet maunally stick an apostrophe in the cell and the cell becomes identified as a label (with the small green triangle in the upper left corner). This is what is needed for the application. So I thought to myself, "add the apostrophe on before you send the file down". But if I try to put the apostrophe in there on the ISeries side and then do the CPYTOIMPF, it comes across to the CSV file looking like this: '3. Is there a parameter or some sort of workaround that would allow this field to show up in the CSV file with this cell defined as a label? Or am I barking up the wrong tree in using the CPYTOIMPF command? Any and all help would be greatly appreciated. Thanks! Bill Howie Programmer/Analyst Coastal Pet Products, Inc. ************ Confidentiality Notice ************ This transmittal is intended exclusively for the use of the individual or entity to whom it is addressed and may contain information that is privileged or otherwise confidential. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized dissemination, distribution, or copy of this communication is strictly prohibited. If you receive this communication in error, please notify us immediately at 1-800-321-0248 and destroy the original message. Thank you! ************ Coastal Pet Products, Inc. ******** -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
