In the old Heidi-Sql-Versions, their was the possibility to change the decimal point to comma in the CSV-Export - I miss this in the new versions!
This was before in CSV-Format encapseled in " not a problem, expl: "12","12,345","ABC"
Regards
1awww.com - Internet-Service-Provider
Detlef Bracker
Decimal-Format
Yes, but then I get between the fields a semikolon (;) and not a comma (,) and thats not good. You must see, that in the EU coutries many programs works with comma for the decimal separator and in same it's been possible, you export texts withs included semicolons - so thats not a good idea to change all semikolons in a export file (excel compatible) to commas!
I mean this was setup before in the export settings, but this I miss now in the new version.
Regards
1awww.com - Internet-Service-Provider
Detlef Bracker
I mean this was setup before in the export settings, but this I miss now in the new version.
Regards
1awww.com - Internet-Service-Provider
Detlef Bracker
Anse, I will not have have an export in excel format! I will have a export in CSV-Format (commad separated fields !!!! not semikolon separated fields !!!!) and in this the decimal fields not with decimal point, but with a comma !!!
I use Heidi-SQL long years for export to differented other programs, the most are not excel programs!
Regards
1awww.com - Internet-Service-Provider
Detlef Bracker
I use Heidi-SQL long years for export to differented other programs, the most are not excel programs!
Regards
1awww.com - Internet-Service-Provider
Detlef Bracker
You will run into import problems if the decimal separator is a comma and the field separator is also the comma. That's exactly the reason why HeidiSQL now offers the Exel compatible output, which magically uses distinct characters for both and detects your local setting for decimal separator. There is no way to export comma formatted floats AND comma as field separator.
No thats not correct, why it´s an absolute difference between the commas for separate fields and a comma for the the decimal position in encapsuled fields!
In other words: a comma in an encapsuled field (string) will not been used for separte fields! Read my example in my initiated statemant!
In other words: a comma in an encapsuled field (string) will not been used for separte fields! Read my example in my initiated statemant!
Please login to leave a reply, or register at first.