[U2] Escaping quotes

2012-08-15 Thread Wjhonson

I'm curious about this escaping quotes thing in the csv format.

Two double-quotes in a row means what exactly?  That it should be converted to 
one double-quote in the output ?
Or that it should be converted to nothing?

What if I encountere three double-quotes in a row, or four or fifteen?
Do I take them out in pairs?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Escaping quotes

2012-08-15 Thread Hona, David
I think this article says it all...

http://en.wikipedia.org/wiki/Comma-separated_values


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, 16 August 2012 10:48 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Escaping quotes


I'm curious about this escaping quotes thing in the csv format.

Two double-quotes in a row means what exactly?  That it should be converted to 
one double-quote in the output ?
Or that it should be converted to nothing?

What if I encountere three double-quotes in a row, or four or fifteen?
Do I take them out in pairs?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be
confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or
disclose the contents, and delete the message and any attachments from your 
system. Unless
specifically indicated, this email does not constitute formal advice or 
commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this
e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users