I need to apply filter on middle part of the value

Hi, I am trying to filter out “845” and “846” in Sales Id.

Not sure on how to do that. Please help me out

Hello @suseearun,

You can utilize the String Manipulation node along with the Rule-Based Row Filter specific rows.

For your reference, I’ve attached configuration images and the workflow.

I need to apply filter on middle part of the value.knwf (9.2 KB)

4 Likes

Thank you. It was much helpful.

Along with the filter “845” and “846” - I also want to filter out “8447” and “208445” (I want to apply it one single line)

I Kindly request you to help me with this too.

@suseearun

You can use the following attached workflow.

I need to apply filter on middle part of the value.knwf (10.6 KB)

3 Likes