Developer forum

Forum » Integration » Normalizing NULL to an empty string

Normalizing NULL to an empty string

Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Hi there,

It seems that when I export to a CSV, I am getting the text NULL for columns with null values:

Is there a way around that? I suppose I could write a custom view that does it, but I am exporting from Ecomproducts so that would be a lot of columns that need special treatment.

Maybe an option on the provider to indicate what null should become?

Imar

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Imar,
we have some feature for that called "Null handling" that looks like that:

So you can specify the Constant value for the null/empty source values, the only problem for that case is that it doesn't have an empty string being inserted as a Constant (maybe we should fix that)
BR, Dmitrij

Votes for this answer: 1
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Thanks again Dmitrij, good to know that it's coming in 10. I'm on 9 for this site, so I'll solve this with a table script.

Imar

 

You must be logged in to post in the forum