MAC address displayed as "Infinity"

[KamasamaK]

I have a CSV file with one of the columns as a MAC address (12 hexadecimal characters) with no separators. A small number of the MAC addresses were displayed as "Infinity" in the preview.

Here is a sample of the first 5 in my file

"MacAddr"
"001E46977290"
"00080E579718"
"407009E70322"
"001E46977274"
"00403670E976"

And they display as follows

This seems to be related to the setting csv-preview.formatValues since when I change it from the default value of always it fixes it.

The only pattern I've found is that these all contain 11 decimal digits and one E.

[jjuback]

As you discovered, you can set the csv-preview.formatValues setting to unquoted. That way, any value enclosed in quotes will be displayed as-is, but unquoted numeric values will respect the csv-preview.numberFormat setting (default: g2).