RE: [KCFusion] Creating a CSV file

[Ellis, Randy]

Have you tried placing single quotes around the text field?   Change #LocSendTo1#   to   '#LocSendTo1#'   Change output="#ResaleNumber#,#LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#" to output="#ResaleNumber#,'#LocSendTo1#',#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#"   Just a thought, Randy -----Original Message----- From: Rick Eidson [mailto:[EMAIL PROTECTED]] 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="">   <cfloop query="QryGetShippingInfo">              <cfset LocRequestorName = "#RequestorFirstName# #RequestorMiddleName# #RequestorLastName#">                                                             <cfset LocSendTo = "#DeliveryAttention##CHR(13)##Replace(LocRequestorName,'  ',' ,'All')##CHR(13)##DeliveryCompany##Chr(13)##TitleCompanyName##chr(13)##TitleCompanyAgent##Chr(13)#">                                                                                                                         <cfif ListLen(LocSendTo, CHR(13)) gt 1>                                                                <cfset LocSendTo1 = ListGetAt(LocSendTo, 1, CHR(13))>                                                             </cfif>                                                                         <cffile action="append" file="#FilePath##FileName#" output="#ResaleNumber#,#LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#">   </cfloop>                           <cffile action="read" file="#FilePath##FileName#" variable="Tabfile">       My problem is that sometimes LocSendTo1 contains a Comma witch causes my CSV file insert another Column. How do I get around this?   Rick