On 20/11/2014 1:20 PM, Guy Harris wrote:
> What do various programs do when reading comma-separated value files if:
>
> 1) the file contains floating-point values
>
I don't know about the rest of the question, but OpenOffice tends to
treat numbers in "e" format as text strings and you have to do a
text-to-columns conversion on them. When you open a CSV it pops up "the
how do you want to parse this" dialog box and you can make whatever
choice of separators suits the file - any combination of comma, tab,
semicolon, spaces, and some others, or a user-specified string.
Andrew
--
There's no point in being grown up if you can't be childish sometimes.
-- Dr. Who