<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

Reply via email to