Nah, I didnt think so... what would your suggestions be of exporting data
from a db into a user readable format?  What approach would you take?
Excel? CSV? etc...

-----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 14:20
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Escaping commas in CSV


> replace(list,",","","ALL")

That's not escaping it, that's just removing it!

How about URLEncoding any data? CSV was never meant to be a good storage
format, just a simple one.  As far as I know, there is no way of doing a
standard escaping of data in CSV

Paul

> At 14:03 29/01/2003 +0000, you wrote:
> >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]

Reply via email to