If Statement Filter

I have a file where I need to do the following.

If [NAME] contains ("th") AND NAME Before "th" + NAME After "th" = [Street Name] then "19m"
Else "Blank"

In other words I do not want to select this record

But I want to keep these

Currently I am using a filter inside the formula tool (Contains = "th")

any help would be greatly appreciated.

thanks

Preparation

Accepted answers

There sure is. Put that all as nested formula in Filter tool.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

your explanation is really confusing.

Can you explain again whats the logic you are using in this filtering which ones you want to keep and which one who want to remove.

Sorry I was trying to figure it out with an If statement would work. I guess my way is confusing.

What I want to do is...

keep this record.

But not this record

As the Street_name column does not match with Name column.

thanks