<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 |
- RE: [KCFusion] Creating a CSV file Rick Eidson
- RE: [KCFusion] Creating a CSV file Ryan Hartwich
- RE: [KCFusion] Creating a CSV file Rick Eidson
- RE: [KCFusion] Creating a CSV file Ellis, Randy
- RE: [KCFusion] Creating a CSV file Greenhagen, Robin
- RE: [KCFusion] Creating a CSV file Ryan Hartwich
- RE: [KCFusion] Creating a CSV file Greenhagen, Robin
- RE: [KCFusion] Creating a CSV file Rick Eidson