8000 Leave leading 0s · Issue #84 · jakob/TableTool · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Leave leading 0s #84

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
kselkowitz opened this issue Nov 28, 2019 · 8 comments
Open

Leave leading 0s #84

kselkowitz opened this issue Nov 28, 2019 · 8 comments

Comments

@kselkowitz
Copy link

When a column value has leading 0s (e.g. UK telephone number 03333056899) when I open it in TableTool the leading 0 is stripped out. I'd like an option to leave those as-is.
@kssi
Copy link
kssi commented Dec 8, 2019

This should NOT even be an option.

CSV doesn't support data type. It stores fields as raw strings that need to be read, displayed and saved as such.

Data interpretation is a job for a fully-featured spreadsheet software, not for TableTool.

Any other behavior is broken and will just ruin the integrity of the CSV file.

This bug is critical. It's safer to use a plain text editor for the time being.

@kssi kssi mentioned this issue Dec 8, 2019
Open
@jtkiley
Copy link
jtkiley commented Jan 11, 2020

+1

Another common case where leading zeros matter is CUSIP identifiers. There is data encoded by position (issuer, issue, and a check digit in the 9th position), and different databases use the 6, 8, or 9 character variants. Without the leading zeros, you couldn't be sure what you were looking at (e.g., a six digit identifier that is actually an eight or nine with leading zeros removed), especially with small numbers of rows. While some can have letters (and would presumably make the column display as a string), that's not guaranteed.

@rgregory1
Copy link

Agreed, I believe this is a critical error as well. I have been searching around for something EXACTLY like this tool, I thought my search was over. A quick check to make sure my leading zero's are there, no such luck.

Without this feature, I'd just use a spreadsheet and have the same results. Also without this feature, I'll only be able to use a plain text editor to ensure my data is kept unchanged by the tool...

@AndrewSB
Copy link

This is a duplicate of #9, this should be closed in favor of that issue

@MEffing
Copy link
MEffing commented Apr 15, 2020

Same here. I've been looking for a CSV editor that will just leave data as it is, without any fancy "smart" format detection features. I thought this was it, but I'm still losing my leading 0's... :-(
I find it incredible that there's nothing that can actually do this properly.

MEffing pushed a commit to MEffing/TableTool that referenced this issue Apr 15, 2020
@miguelfenoglio-dlink
Update CSVReader.m
bd0d9ae 
Updated as per YWangScience's comment for fixing issue jakob#9 and jakob#84.
@MEffing MEffing mentioned this issue Apr 15, 2020
Open
@rgregory1
Copy link

They are out the MEffing, I use Easy CSV Editor for Mac, it's wonderful and works as expected.

@MEffing
Copy link
MEffing commented Apr 16, 2020

Thanks. I was hoping for something free, but I can't keep wasting time. I've downloaded it now and my data looks correct. Finally!

@jpdenford
Copy link

I have run into the same issue. Quite frustrating as I love this tool!

@M-M-M-M M-M-M-M mentioned this issue Sep 12, 2021
Open
@LittleDarkEye LittleDarkEye mentioned this issue Oct 27, 2021
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
7 participants
@AndrewSB @jtkiley @jpdenford @MEffing @kselkowitz @kssi @rgregory1
0