ryu1kn
alwaysQuote option doesn't quote null fields
Hi. I'm using csv writer to integrate with a warehouse and they require that all values, including null values, in the csv be double quoted. I set the alwaysQuote option to true, but it looks like null values still get output as
,,,,,
rather than
,"","","","",
Would it be possible to add a new option to double quote null values or to update the existing option so that it works that way?
Hi @deakinhead , thanks for the suggestion. I want to avoid making a breaking change at this stage; so probably need to introduce a new flag. Naming would be a struggle. Wish alwaysQuote gave quotes even for empty fields...
@ryu1kn Thanks for the quick response. quoteEmptyFields sounds good to me.
How long do you think it would take to add?
Hi @ryu1kn , i have opened a PR to add this param into the writers :)
https://github.com/ryu1kn/csv-writer/pull/97
This makes the writer accept quoteEmptyFields param, that makes nullish (null/undefined) values to be written with empty double-quote "" on the CSV generation.
