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?
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?
-
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
Please sign in to leave a comment.
Comments 1