I want to filter out:

{Comments 2} that contain the text "ABC"

Can anyone help?

FIND("ABC", {Comments 2}, 1) will return a 0 if ABC is not contained in {Comments 2}. If it is contained, it will return the position of the A, which will be a number higher than 0.

The "1" parameter tells it to search the whole field. If you put a higher number there, it will only search from that position on.

Steve

PS - Thanks to Leigh for teaching me this a few days ago, I haven't had a chance yet to forget it!

HI Steve,

So I added a column and I'm getting the results, 0 and 1. How do I filter out 0 now?

I tried {Name of Column} = 1 but it's not working.

Susan:
You don't need to add a column (though it's initially useful to verify that you have the formula working). You need to add a Filter (or add to an existing Filter) where you include only records where the result of Steve's formula = 0.

Hi Susan,

If you want to select the rows where ABC is found in the Comments 2 field, use the FIND formula Steve indicated in a filter where the result is >0. If you want to select rows that don't have ABC in the Comments 2 field, use the same FIND formula but =0.

Filter 'Comments with ABC': FIND("ABC", {Comments 2}, 1) >0
Filter 'Comments without ABC': FIND("ABC", {Comments 2}, 1) =0