Replace with null

CloverDX Platform
1

I’m having an issue trying to replace with null.

for example;

I have a field that can sometime contain just quotes(“”), or “STRING”,

currently i’m using this function – replace($in.0.item_number, “\”", “”);

so when a field that contains “STRING” goes through, the result is STRING

but when a field with “” goes through, it gives me an empty string – i want that field to be null.

i tried out.0.item_number = removeNonAscii($in.0.item_number) but that doesn’t accomplish my goal either.

any solutions?

2

Hi,

Thank you for your inquiry. What you’re trying to accomplish can actually be done by configuring the metadata property “Quoted Strings” and setting it to “true” - all quotes will be removed from columns containing quotes and thus will be replaced with null values. I hope this helps.

Best Regards,
George Darvehn