If Statement Filter

[corinne]

Hi 

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

[atcodedog05]

Hi @corinne 

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.

[corinne]

Hi @atcodedog05

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

[atcodedog05]

Hi @corinne 

Here is a workflow for the task.

Input: I have added few more examples.

Output:

Basically the expected add words are st(1st),nd(2nd),rd(3rd),th(4th) only these are the occurring keywords.

Workflow:

Hope this helps 🙂

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

[corinne]

Thanks this is helpful. 

Is there a way not to create a new column?

reason is as per data specs I am not supposed to manipulate the data in the [Name] column. 

Thanks

[atcodedog05 · Accepted solution]

Hi @corinne 

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 😀👍