Delete cells by rule

Good morning, there are errors in a column, I would like to know how I can delete the content of the cells that are wrong (they all follow the same pattern: / U).
Thank you very much in advance

Hello kelet,

you can use a column expression node.
Use the contains() function to find if the pattern is contained inside the cell, and if true write an empty cell “”, else write the old value.


1 Like

Hello, Ielloba. Thanks for your input, I have installed the expression pack and managed to get the desired result.


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.