> Yes, and what does this matter? Aren't all CSV files 
> "supposed" to be the same?

Hey Mike, 

It matters because I've seen A LOT of bugs in Excel when saving/exporting flat 
files. Some of the issues that I have encountered include missing delimiter 
characters when the last field of a record is blank (resulting in data errors 
because some records are missing fields when, in fact, they aer not), extra 
spaces being removed (like what you've reported), leading zeros from field 
(such as a ZIP code field) being removed, and more.

You are absolutely correct when you say that they are "supposed" to be the same 
(and the use of the quote marks is very appropriate here, too). However...

What makes this even more annoying, IMNHO, are two things: a) it doesn't matter 
if you are exporting a CSV file or a tab-delimited text file and b) the first 
20 records or so usually export fine so if you just open the data in a text 
editor and look at the first several records, everything seems to be in order.

Finally, thnk of it this way - if it didn't matter, how would I have known to 
ask?  <GRIN>

There are some ways to fix the data (outside of Excel) before feeding it to 
FusionPro. But first, how may records are in your data? That will help me 
determine the best/fastest/easiest way for you to fix the data.

Rob

 
*******************************************************************
Rob Domaschuk
Training & Communications Developer,
Printable Technologies™, Inc.
 
Member; National Association of PhotoShop Professionals
 
 
"Great ability develops and reveals itself increasingly
 with every new assignment."
      - Baltasar Gracian (1601-1658)
 
*******************************************************************

--
Users of FusionPro Desktop have unlimited free email support. Contact Printable 
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm

--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--


--
Note:  All e-mail sent to or from this address will be received or otherwise 
recorded by the e-mail recipients of this forum. It is subject to archival, 
monitoring or review by, and/or disclosure to someone other than the recipient. 
Our privacy policy is posted on www.printplanet.com
--

Reply via email to