Re: String and field delimeters when doing a CPYTOIMPF

Have you tried it?  My experience is that the only time you will have a
problem is when you have an embedded apostrophe-comma-apostrophe (no blanks)
  
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 06/15/05 13:44:58
To: midrange-l@xxxxxxxxxxxx
Subject: Re: String and field delimeters when doing a CPYTOIMPF
 
Martin,
 
That will work with fields with commas but not fields with apostrophes.  The
embedded apostrophe will be interpreted as the end of field.  There needs to
be some sort of shift out character, double apostrophe, or hex
representation for embedded apostrophes but I don't know what that would be.
In our shop we use an odd CSV format with x'FD' as a comma delimiter and no
string delimiter to avoid the problem.
 
Paul
 
--
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333
 
Martin wrote
 
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.
 
 
 
--
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.
 
 
.