double quotes is the usual qualifier for csv's... -----Original Message----- From: Douglas Humphris Sent: 29 January 2003 14:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Escaping commas in CSV
You need to qualify the columns so that any comma inside a column is not mistaken for a seperator. This function might be useful, but watch you don't qualify the commas that don't separate: listqualify(list, qualifier, [delimiters], [elements]) HTH Doug -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 14:04 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Escaping commas in CSV brain fart... Whats the best way to escape commas from data so it can be written safely to a CSV file....? N -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
