Format issue with NULL values [message #682021] |
Sun, 27 September 2020 02:38 |
![](http://www.gravatar.com/avatar/a92f8065cb73589e469d2f7e91d5a4a6?s=64&d=mm&r=g) |
zooby2doo
Messages: 1 Registered: September 2020
|
Junior Member |
|
|
Hi,
I need to create a spool file in CSV format. like "col1";"col2";"col3";..."col80"
with SET MARKUP CSV ON DELIMITER ';' option I can get desired results only for non null columns.
if I use set null '""' then i get required format "" (2 double quotes) only for null columns in number datatype but for the case of varchar datatype i get """""" (6 double quotes).
Could you please advise how to get "" (2 double quotes for null values for varchar datatype column)
Thanks.
|
|
|