TableTool icon indicating copy to clipboard operation
TableTool copied to clipboard

Published 20 hours ago • verified publisher icon jakob

Does not parse CSV string with a leading equals (=) correctly

Open alexboots opened this issue 6 years ago • 0 comments

Excel / Numbers and TableTool all delete leading 0's in numbers when opening CSV files. 0123 becomes 123 when opened.

To stop this from happening, when exporting the CSV, you can an equals (=) before the string: "yada",="0123","yada" - Excel and Numbers will keep the leading 0 and not drop it .

This breaks up the format when opening in Table Tool: From top to bottom, Numbers.app, TableTool, Raw CSV: screen shot 2019-01-10 at 6 29 30 pm

If you remove the leading = it displays correctly, but drops the leading 0: From top to bottom, Numbers.app, TableTool, Raw CSV: screen shot 2019-01-10 at 6 32 05 pm

alexboots avatar Jan 10 '19 23:01 alexboots