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

Exporting Excel CSV generates a "\N" value in NULL fields

User, date Message
Written by mpmaggi
10 months ago
Category: Import/Export
2 posts since Wed, 30 Oct 13
Hello,

I'm using HeidiSQL 8.1 and everytime i export data with Excel CSV format, whenever the field is NULL, the excel gets a "\N" in the cell.
This issue did not happened with 8.0.

Tested with last build 4591 and it's the same as described.

Written by ansgar
10 months ago
4988 posts since Fri, 07 Apr 06
There is a new optional "NULL value" input box in the export dialog, which you may not have noticed. Watch out for it in the lower right of the grid export dialog. \N is just the default value for it.
Written by mpmaggi
10 months ago
2 posts since Wed, 30 Oct 13
Oh, sorry then, totally my bad.

Awesome improvement, by the way!

Thanks a lot!!
 

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