Wireshark mailing list archives

Re: CSV data and decimal separators


From: Guy Harris <guy () alum mit edu>
Date: Thu, 20 Nov 2014 18:40:04 -0800


On Nov 19, 2014, at 8:05 PM, Guy Harris <guy () alum mit edu> wrote:

From a quick experiment, using Excel for Mac 2011, with a locale temporarily tweaked to use , as the decimal 
separator and . as the thousands separator, the wizard for importing data, if I try to import a CSV file, offers an 
option (under "Advanced..." in step 3 of the import wizard) to, on a per-column basis, control what characters to use 
as decimal and thousands separators when importing the file.  It offers , as a decimal separator and . as a thousands 
separator by default in that case.

In an earlier step, it lets you specify the field separator (from a set that includes tab, semicolon, and comma).

It doesn't base the default for the separators on the locale; it appears, for what it's worth, to default to , as field 
separator, . as decimal separator, , as thousands separator.

___________________________________________________________________________
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: