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

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

mpmaggi posted 12 months ago in Import/Export
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.

ansgar posted 12 months ago
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.
mpmaggi posted 12 months ago
Oh, sorry then, totally my bad.

Awesome improvement, by the way!

Thanks a lot!!

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