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]
RE: [KCFusion] Creating a CSV file
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 PMTo: 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
RE: [KCFusion] Creating a CSV file
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]
RE: [KCFusion] Creating a CSV file
Robin, Will that be a problem with numeric fields if the data file includes comma based numbers? Example: 43,832.76 Should you have everything quoted? Robin, Greenhagen, 43,832.76, Lenexa, KS Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Greenhagen, Robin Sent: Monday, October 15, 2001 3:32 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Creating a CSV file 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. __ 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]
RE: [KCFusion] Creating a CSV file
Yes, if your app uses the commas. Most of the time the commas are only available in the presentation logic (not in the DB). I am not sure that Excel will recognize 43,832.76 as numeric (so that you can do cool stuff like SUM() on it) but I know it will see 43832.76 as a number. Cheers! Robin Greenhagen President GreenSoft Solutions, Inc. -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 3:35 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Creating a CSV file Robin, Will that be a problem with numeric fields if the data file includes comma based numbers? Example: 43,832.76 Should you have everything quoted? Robin, Greenhagen, 43,832.76, Lenexa, KS Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Greenhagen, Robin Sent: Monday, October 15, 2001 3:32 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Creating a CSV file 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. __ 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]
RE: [KCFusion] Creating a CSV file
Title: RE: [KCFusion] Creating a CSV file I cannot specify a Qualifier so any other characters are out. This is not for a spreadsheet. It is for a UPC shipping application. Rick -Original Message- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 3:38 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Creating a CSV file Yes, if your app uses the commas. Most of the time the commas are only available in the presentation logic (not in the DB). I am not sure that Excel will recognize 43,832.76 as numeric (so that you can do cool stuff like SUM() on it) but I know it will see 43832.76 as a number. Cheers! Robin Greenhagen President GreenSoft Solutions, Inc. -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 3:35 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Creating a CSV file Robin, Will that be a problem with numeric fields if the data file includes comma based numbers? Example: 43,832.76 Should you have everything quoted? Robin, Greenhagen, 43,832.76, Lenexa, KS Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Greenhagen, Robin Sent: Monday, October 15, 2001 3:32 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Creating a CSV file 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. __ 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]
