? use a double quotes for a comma seperated file? I am thinking that using Flat files such as CSV is bad and I am looking into alternatives. All I will be doing it exporting data from SQL Server using CF either via inline SQL or SP and then providing a link for a user to download a readable format...?
N -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 14:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Escaping commas in CSV 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] -- ** 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]
