export to csv, the separator is ;

[expired user #5329]'s profile image [expired user #5329] posted 13 years ago in Import/Export Permalink
When I use tools > export grid data to file.
Pick .csv

The columns aren't opened properly in excel because the separator is ;

It'd be nice to have an option that exports everything, not just limited to 1000 rows.


I'm using v6.0.0.3603
ansgar's profile image ansgar posted 13 years ago Permalink
Set your CSV characters in Tools > Preferences > Export .

To export more than the limited number of rows in a grid just press Ctrl+End to fetch all, before exporting.
[expired user #5329]'s profile image [expired user #5329] posted 13 years ago Permalink
Thanks a lot!
This is nice tool, I had tried mysql workbench originally but I couldn't even switch between the tabs without some error message coming up.
ansgar's profile image ansgar posted 13 years ago Permalink
See issue #1499 for enhancements on this feature.
ansgar's profile image ansgar posted 13 years ago Permalink
In the new dialog in r3796 you can simply select "Excel TSV" which sets the right delimiters.

Please login to leave a reply, or register at first.