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!
Posted by: SusanTennier
Re: Gridview Filter - 03/29/13 04:15 PM
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