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.

RB

1 Like

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

2 Likes

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