distal-attribute
distal-attribute
distal-attribute
distal-attribute

Decimal-Format

User, date Message
Written by 1awww.com
3 years ago
Category: Import/Export
5 posts since Wed, 05 Oct 11
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
Written by ansgar
3 years ago
4962 posts since Fri, 07 Apr 06
Did you notice the "Excel compatible" grid output? I guess you want to set the comma for Excel?
Written by 1awww.com
3 years ago
5 posts since Wed, 05 Oct 11
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
Written by ansgar
3 years ago
4962 posts since Fri, 07 Apr 06
Well I'm also from the EU, germany to be exact. However, in Excel export, if your decimal separator is the comma, HeidiSQL detects that and uses semicolon as the field separator. This is recommended by Microsoft and works perfectly in Excel.
Written by 1awww.com
3 years ago
5 posts since Wed, 05 Oct 11
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
Written by ansgar
3 years ago
4962 posts since Fri, 07 Apr 06
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.
Written by 1awww.com
3 years ago
5 posts since Wed, 05 Oct 11
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!
Written by ansgar
3 years ago
4962 posts since Fri, 07 Apr 06
No need to shout at me, man.

Well in Excel that *is* a problem, for why HeidiSQL does the mentioned trick to overcome that. For your special case there is no solution in HeidiSQL I'm afraid. So you're left to do that with a search/replace dialog in some editor.
 

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