Wireshark-users: Re: [Wireshark-users] CSV data and decimal separators
Date Index · Thread Index · Other Months · All Mailing Lists
Date Prev · Date Next · Thread Prev · Thread Next
From: Guy Harris <guy@xxxxxxxxxxxx>
Date: Wed, 19 Nov 2014 20:33:22 -0800
On Nov 19, 2014, at 8:16 PM, Andrew Hood <ajhood@xxxxxxxxx> 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?