• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with Filter Function

DJ

Member
Hi,

I have a dataset named "AllData". It has a column named as "ObjectID". I want a filtered table basis the criteria that values in ObjectID column contains a value string "SearchString".

The formula syntax for filter function is FilteredDataTable = FILTER(AllData,AllData[ObjectId]="SearchString") but it doesn't help because it just returns data by filtering values which are exactly equal to "SearchString". Whereas I want to get filtered data table which contains "SearchString" in it.

Please help.

Thanks,
DJ
 
Use FIND, or SEARCH function in Filter.
Note that to use FIND/SEARCH inside FILTER function, you'd need to supply 4th optional argument.
Ex:
FILTER(Table,SEARCH("String",[COLUMN],,0)>0)
 
Back
Top