× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



                                                                            
 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.  ********



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.