I need to apply filter on middle part of the value

[suseearun]

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

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

[tqAkshay95]

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)

[suseearun]

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.

[tqAkshay95]

@suseearun

8447

@suseearun

You can use the following attached workflow.

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

[tqAkshay95]

@suseearun,

if you have got the solution, please mark it with a green tick.