RE: [KCFusion] Creating a CSV file

2001-10-15 Thread Ryan Hartwich
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

RE: [KCFusion] Creating a CSV file

2001-10-15 Thread Ellis, Randy
Have you tried placing single quotes around the text field? Change #LocSendTo1# to '#LocSendTo1#' Change output="#ResaleNumber#,#LocSendTo1#,#DeliveryStreet#,#DeliveryCity#,#DeliveryState#,#DeliveryZip#" to

RE: [KCFusion] Creating a CSV file

2001-10-15 Thread Greenhagen, Robin
, 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

RE: [KCFusion] Creating a CSV file

2001-10-15 Thread Ryan Hartwich
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

RE: [KCFusion] Creating a CSV file

2001-10-15 Thread Greenhagen, 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

RE: [KCFusion] Creating a CSV file

2001-10-15 Thread Rick Eidson
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