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]
