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]
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
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
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
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
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 ',' ,'All')##CHR(13)##DeliveryCompany##Chr(13)##TitleCompanyName##chr(13)##TitleCompanyAgent##Chr(13)#"> LocSendTo1 = ListGetAt(LocSendTo, 1, CHR(13))> LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#"> 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
Title: RE: [KCFusion] Creating a CSV file
I am checking to see if I can use a TAB. The problem is this isn't going to be read with Excel but imported into a UPS/RPS application.
Rick
-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
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
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
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]
[KCFusion] Creating a CSV file
',' ,'All')##CHR(13)##DeliveryCompany##Chr(13)##TitleCompanyName##chr(13)##TitleCompanyAgent##Chr(13)#"> LocSendTo1 = ListGetAt(LocSendTo, 1, CHR(13))> My problem is that sometimes LocSendTo1 contains a Comma witch causes my CSV file insert another Column. How do I get around this? Rick
