Support for <> qualifiers in String to Number node


There are times I have numerical data with <> qualifiers in them which of course leads to a string data type column.

using the string to number node results in all these to become missing cells, is it possible to have an option in the node for it to ignore these qualifiers during the conversion so you can still get the number out in your new double data type column. Even better would be for it to ignore all non numerical characters.

i appreciate this can be done using loops and string replacer, but it's hardly elegant or quick.


For columns with a lot of missing values (after pivoting and thus a column of undefined type), the string to numbers node also doesn't work. I had to use the string manipulation node to translate the numbers to actual numbers for sorting, etc purposes.