I’ve a column that I had to import as string (excel reader).
It contains mostly numbers but sometimes users put a “TBC” when they don’t have the info.
So I want to use Column Expressions Node beause I’ve mutliple columns to do (instead of having multiple rule engine), but I can’t figure out how to make it works.
I tried like this to check if the cell can be converted as double, if no put a missing value, if yes then convert it (type of column is defined as “Double” as well)
The Multi-Column String Manipulation node is how I would go about it as well since it can dynamically adapt to different header names. It also gives you the added flexibility to designate all your included columns via Regex or by prior formula test to route for conversion.
I also didn’t know about Try / Catch in the Expressions Node. Thanks @duristef!