|
If you prepare each and every field with apostrophes at the beginning and end and use a comma delimiter all fields should work correctly, even fields with apostrophes and commas in them. At least, that works for me.... I think. --------------------------------- Booth Martin http://www.martinvt.com --------------------------------- -------Original Message------- From: Midrange Systems Technical Discussion Date: 06/15/05 07:16:51 To: Midrange Systems Technical Discussion Subject: RE: String and field delimeters when doing a CPYTOIMPF That's what I've been doing as well. I just wanted to make sure there wasn't something I was missing. -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of pnelson@xxxxxxxxxx Sent: Tuesday, June 14, 2005 3:23 PM To: Midrange Systems Technical Discussion Subject: Re: String and field delimeters when doing a CPYTOIMPF I've always had to "prepare" the file ahead of time with an RPG program that looks for quotes and apostrophes in various fields and replace them with blanks. I recall some discussion in the archives regarding someone dealing with a 15" pizza. You can guess that I missed lunch today... :-)) -- Paul Nelson Arbor Solutions, Inc. 708-670-6978 Cell pnelson@xxxxxxxxxx -- 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-2025 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.