jakob / jakob/TableTool

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

Open
#72 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Objective-C
Stars
1.4k
Forks
107
PR merge metrics
No merged PRs in 30d

Description

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

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file or test is identified in the issue. Reproduce the example in TableTool, then locate the CSV import/parsing entry point and add coverage for a quoted value beginning with `=`. Done means the sample remains correctly separated into CSV fields while preserving the intended displayed value.

Written by the indexing model from the issue text.

Assessment

Tech stack
objective-c
Domain
desktop
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.