cancel
Showing results for 
Search instead for 
Did you mean: 

Formula help

SOLVED
Brad1
11 - Bolide

Formula help

Need some formula help.  Need a formula to account for this:

 

Needs to find any word in the cell that contains "at"

 

So it would find

 

At

Cat blah

attach

 

but not

Art

Amout

3 REPLIES 3
Brad1
11 - Bolide

Formula help

Need some formula help.  Need a formula to account for this:

 

Needs to find any word in the cell that contains "at"

 

So it would find

 

At

Cat blah

attach

 

but not

Art

Amout

JohnJPS
Aurora

Re: Formula help

This ...

Contains([field],"at")

... will return true or false for you.

bpatel
Alteryx Alumni (Retired)

Re: Formula help

Try to use the filter tool. Contains([field name],"at")

 

Hope this helps!

Re: Formula help

Thx