How to automatically parse the numeric value for a column when the file is opened?

[lulunac27a]

I want to see the file contents with columns with only the numeric values in all rows should display the numeric values automatically instead of manually type # for integer values or % for floating point values. How can I do this?

[frosencrantz]

This thread might have information that is useful: #1488

In that thread look for knownCols and afterLoad. Also mentioned in that thread, look for "autotune" and skeept's guessType command.

[lulunac27a]

When I open the file with numeric values, the columns that have numeric values should convert from string to numeric values automatically instead of manually converting the column formatting type.

[saulpw]

@lulunac27a You might want to use Microsoft Excel, which works as you expect: https://www.howtogeek.com/816620/microsoft-is-finally-fixing-excels-data-conversion-problem/

[lulunac27a]

What about other file types like CSV, JSON, and TSV?