Wireshark mailing list archives
Re: CSV data and decimal separators
From: Andrew Hood <ajhood () fl net au>
Date: Thu, 20 Nov 2014 15:16:01 +1100
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 ___________________________________________________________________________ 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)