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
Have
you tried placing single quotes around the text field?
Change
#LocSendTo1# to '#LocSendTo1#'
Change output="#ResaleNumber#,#LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#"
to
, 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
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
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
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