Thank you, I have been trying to find an answer to this problem for days myself, as we are about to do some major data extraction to excel. What a valuable list.
Regards, J Garratt > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno > Sent: Tuesday, 17 January 2006 11:38 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] CSVs' (Different Question) > > > Mark Johnson wrote: > > Where do I quote these? > > "A","B","C","12345","000123" > > The info I posted about single quotes in my last post wasn't helpful in > this context. Let me try this way: > > A,"B","12,34",Hi "World" > Excel doesn't need quotes unless you're doing something special, which > explains why the A and B values are exactly the same. The "12,34" is > special because it embeds a comma. Quotes are also needed when spaces are > embedded, although sometimes leading or trailing spaces may also get > removed. The \Hi "World"\ example is interpreted as alpha in the first > place, so any quotes embedded in that value are considered part o the text > string. > > 000123,="000123" > The number with leading zeros is recognized it as numeric, so 000123 > becomes 123 in the sheet. The ="000123" value tells Excel that this is a > formula (preceded by equal sign). The formula returns a string which is > not reinterpreted as above. > > "12/10/05" > This date, even in quotes, is interpreted because there is not a forumula > telling Excel to do otherwise, and will get converted to display > "12/10/2005". The value itself will be converted to an internal numeric > much like the internal Pick date. > > "=""12/10/05""" , ="12/10/05" > These two values show equivalent formulas for expressing the date as a > string, not a date to be converted as above. This just goes to show that > sometime you need to "escape" a quote by preceding it with another quote. > > > There are no formal standards which govern how CSV files work. There are > generally accepted conventions, but of course these aren't all followed by > Excel. Using the guidelines above you can experiment with > certain kinds of > data to see how it behaves. > > And none of this is related to U2. There are thousands of websites with > this sort of information available. > > T > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
