TableTool
TableTool copied to clipboard
Leave format of opened files
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!
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 [email protected]:
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.
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!
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
I can confirm broken in the latest version. We are seeking help to implement the solution to this one.