String Replacer Bug

If you choose to replace the entire cell contents which matches string "x", and as replacement text choose 'nothing', then the resultant output contains cells with nothing in them, but are not classed as missing value cells, i.e. the Missing Value node does not recognise these empty cells for manipulating. Why is this ?



By 'nothing' you mean an empty string? An empty string is not a missing value, it's, well, an empty string.

Hmm, okay. I was under the impression they are the same thing !

So is there no way to convert a cell contents of a specific string into an empty value ?


You can use the String Manipulation node with an expression similar to toNull(replace($Col0$, "Something", ""))

Ok, great thanks.