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
ers!
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
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
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 inser
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#,#Delivery
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, 2
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
