Hi @ArjenEX
thanks for your fast reply.
But unfortunately it doesn’t work. I don’t get the content to null so that I have the “?” in the column.
How can I change that?
Best regards,
Jurgen
It’s almost inpossible to troubleshoot without having an example. Can you upload a (anonymized) sample from your actual source similar to what you have used in your first post? A workflow with the data preloaded also works.
Usually a RegexPlace of [^0-9a-zA-Z+-.,!@#$%&*()^:;\/|<>"'_] or similar should be sufficient to get it to null.
Hi ArjenEX,
I did the following and now it works.
In the String Manipulation I used the expression:
toNull($COLUMN1$)
And now the Missing Value Node works proper.
Thanks for your help.
Jürgen