Re: CSV data and decimal separators

[Guy Harris <guy () alum mit edu>]

On Nov 19, 2014, at 8:16 PM, Andrew Hood <ajhood () fl net au> wrote:

> 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

Let me rephrase that as

        1) the file contains non-integer numeric values

The "e" isn't what I'm asking about, as I think that's the same in all locales; it's the "."/"," that I'm asking about 
here.

> 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.

Does it also offer you a choice of decimal and thousands separators?

___________________________________________________________________________
Sent via:    Wireshark-users mailing list <wireshark-users () wireshark org>
Archives:    http://www.wireshark.org/lists/wireshark-users
Unsubscribe: https://wireshark.org/mailman/options/wireshark-users
             mailto:wireshark-users-request () wireshark org?subject=unsubscribe