Wireshark mailing list archives
Re: CSV data and decimal separators
From: Guy Harris <guy () alum mit edu>
Date: Wed, 19 Nov 2014 20:33:22 -0800
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 valuesI 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
Current thread:
- CSV data and decimal separators Guy Harris (Nov 19)
- Re: CSV data and decimal separators Guy Harris (Nov 19)
- Re: CSV data and decimal separators Guy Harris (Nov 20)
- Re: CSV data and decimal separators Guy Harris (Nov 20)
- Re: CSV data and decimal separators Guy Harris (Nov 21)
- Re: CSV data and decimal separators Guy Harris (Nov 21)
- Re: CSV data and decimal separators Guy Harris (Nov 20)
- Re: CSV data and decimal separators Guy Harris (Nov 19)
- Re: CSV data and decimal separators Guy Harris (Nov 20)
- Re: CSV data and decimal separators Guy Harris (Nov 19)
- Re: CSV data and decimal separators Andrew Hood (Nov 20)