search

jakob / TableTool

A simple CSV editor for the Mac
MIT License
1.3k stars 92 forks source link

Leave format of opened files #23

Open Brixy opened 7 years ago

Brixy commented 7 years ago

Thank you for this nice piece of software.

Is it intended that Table Tool does not recognise the CSV format of the file (e. g. comma vs. semikolon seperated, quoted vs. non-quoted)? In my context I need to edit various differently formatted CSV files and it is essential that the format is never changed.

Thanks a lot!

jakob commented 7 years ago

Table Tool should auto-detect the format of a CSV file. If it doesn't, can you provide a copy of the file (with private data removed) so we can see what the problem is?

Jakob

Am 05.03.2017 um 15:54 schrieb Brixy notifications@github.com:

Thank you for this nice piece of software.

Is it intended that Table Tool does not recognise the CSV format of the file (e. g. comma vs. semikolon seperated, quoted vs. non-quoted)? In my context I need to edit various differently formatted CSV files and it is essential that the format is never changed.

Thanks a lot!

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

Brixy commented 7 years ago

Thanks, jakob!

As soon as I save a CSV file in any format without quotes, quotes are wrapped around all items.

From

Year;Make;Model;Length
1997;Ford;E350;2,34
2000;Mercury;Cougar;2,38

to

"Year";"Make";"Model";"Length"
"1997";"Ford";"E350";"2,34"
"2000";"Mercury";"Cougar";"2,38"

or from

Year,Make,Model,Length
1997,Ford,E350,2.34
2000,Mercury,Cougar,2.38

to

"Year","Make","Model","Length"
"1997","Ford","E350","2.34"
"2000","Mercury","Cougar","2.38"

This behaviour also applies when saving a file without any modifications.

Thank you!

llamafilm commented 6 years ago

This is a problem for me too. When I open a CSV which does not have any quotes, Table Tool guesses wrong and thinks it has quotes. If I don't notice and forget to change it, then it writes quotes into the file when I save it, and this isn't even noticeable until I open the file again in a standard text editor. If it helps, here is a sample file which exhibits this problem. report-411951434879-2017-02-01.csv.txt

fulldecent commented 6 years ago

I can confirm broken in the latest version. We are seeking help to implement the solution to this one.