Comment Re:Excel doesn't even do CSV correctly... (Score 1) 467
I believe proper quoting will fix that problem. All CSV files I've seen exported from OOo seem to quote automatically, but not sure about Excel. Try:
"Smith","Joe","E","121 Mockingbird Lane","Metropolis","BS","(330)555-1212","0023456789"
Normal numbers naturally don't need quoting. You can even embed quotes in fields by doubling them up:
0123,"5'2""","Height"
Which is the number 123, followed by 5'2" as in 5 feet 2 inches, and Height.
Yes, the quotes are correct.
"Smith","Joe","E","121 Mockingbird Lane","Metropolis","BS","(330)555-1212","0023456789"
Normal numbers naturally don't need quoting. You can even embed quotes in fields by doubling them up:
0123,"5'2""","Height"
Which is the number 123, followed by 5'2" as in 5 feet 2 inches, and Height.
Yes, the quotes are correct.