different delimiter.
Instead of a comma, if they can use a '|' (pipe symbol found to left
of 'Z' on keyboard) or a ~ (tilda) character then these tend not to
crop up in 'ordinary text'.
You could 'parse' the data yourself. That is look for the text
qualified " using the find function, mark this character position as
the start of a text field and look for the closing ", mark this as the
end, now for the characters within this region strip out any delimiter
characters. Repeat for rest of string.
----- Original Message -----
From: Brant Winter <[EMAIL PROTECTED]>
Date: Mon, 6 Sep 2004 19:31:09 +1000
Subject: RE: escaping " character
To: CF-Talk <[EMAIL PROTECTED]>
It will be a regular transfer, almost on a daily basis. I am not sure if I
am going to be able to get the other party to supply the data with double
quotes and commas as in a text qualifier.
----------------------------------------------------------------
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer. It is the
responsibility of the recipient to ensure that the onward
transmission, opening or use of this message and any attachments will
not adversely affect its systems or data. Please carry out such virus
and other checks, as you consider appropriate. To the fullest extent
allowed by law, no responsibility is accepted by Haematology &
Oncology Clinics of Australasia for any virus damage caused by this
message.________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
