The csv 'standard' for fields containing a quote is double quote So for the data Col1 = col1data Col2 = col 2 "is here" !, and it is good Col3 = end You have a csv of "col1","col 2 ""is here"" !, and it is good","end"
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2009 16:21 To: U2 Users List Subject: Re: [U2] Simple Export to Excel >>Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if >>you have valid data like 123, 0123 & 00123. Excel will make then all 123. I agree. You can quote text values, but this is problematic if the data itself contained quotes. It helps some if you define the fields as text instead of general in the import screen. But there are still problems. I have tried to convince users not to overuse Excel, but they usually act like I just ran over their favorite puppy. Charles Shaffer Senior Analyst NTN-Bower Corporation _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
