Forum Stats

  • 3,751,487 Users
  • 2,250,366 Discussions
  • 7,867,437 Comments

Discussions

Avoid Empty Quoted Strings for NULL Varchar/Char data while exporting to csv

I'm using PUT_LINE_NCHAR to write data into csv's

here I can see that NULL strings are written in csv's as empty quoted string ("") for char and varchar columns and for int type columns I can see empty unquoted string in csv (blank/zero length)

Now, I want to avoid those empty quoted string for NULL data of char and varchar columns instead need unquoted empty string


how can I achieve???


Thanks in advance