Actually, you probably want a quote/comma delimited file. Where all non-numeric flds get "" around them.
"Robin", "Greenhagen", 16.49, "Lenexa, KS" Cheers! Robin Greenhagen President GreenSoft Solutions, Inc. -----Original Message----- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Creating a CSV file Do you need to use a comma for your CSV? (don't laugh!) Really, most spreadsheets allow you to use any symbol as a separator and you specify it upon insert. If your end user does not require a comma, maybe you could use a less common symbol inside of your text strings. (i.e. make it a {SV file, or a |SV, so that your commas can remain in LocSendTo1 without messing up a CSV file). Ryan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rick Eidson Sent: Monday, October 15, 2001 2:53 PM To: CF-List (E-mail) Subject: [KCFusion] Creating a CSV file <cffile nameconflict="OVERWRITE" action=append file="#FilePath##FileName#" output=""> My problem is that sometimes LocSendTo1 contains a Comma witch causes my CSV file insert another Column. How do I get around this? Rick ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]