Search and remove a string within a single row

Hello community,
I am struggling with a string replacement and a loop to do this. I have the following table:

The yellow items in the Main Haz column are my input. value. All the strings with this value should be removed in the same row only.
How can I loop this or handle this?

The expected result would be:
image

Would be great to get some support.

Hello @Saltan ,

here is a workflow I have prepared:

Have a nice evening,
RB

Hey thx that worked out but I have a little problem I noticed. Is this also possible to do with wildcards? it would be better for me to remove everything from a column that begins with the matching number so my Main Haz column would be like
image

So the WF should delete every cell entry that matches the number in the Main has column. So how can I use wildcards here?
for instance: 3 should delete 3,III and 3,II and 3,I

you could use regex nodes for that (e.g in string manipulation node).
A way to try your work without a loop could be the column aggregator node. (I borrowed @lelloba great workflow for that) Here is an example even if it needs some additional “fine tuning” (e.g. insert column headers and column filtering)
br

1 Like

Hello Daniel,
sound good but could you tell me what the regex code would be? I am not very familiar with this.

Hello @Saltan ,

Daniel’s suggestion to avoid loop is correct and would lead to an increase in efficiency. I don’t know how big your dataset is: if you think it could be useful to be more efficient, we can change strategy and help you recreate a new workflow. Thank you @Daniel_Weikert for the advice! :slight_smile:

I have updated my previous workflow. The v2 works with regex and looks for the number before the comma (ex 6,I → 6).

Tell us if you think it can work for you.

Have a nice weekend,
Raffaello

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