https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59423#M13071 The Filter action is intended to return all rows matching the criteria. Your requirement seems to be one step more - to filter out unwanted rows and unwanted columns. The current collection utility doesn't have that functionality, but I think you can achieve what you want with another couple of lines of code. Something like this: 'Get filtered rows Collection_In.DefaultView.RowFilter = Filter Collection_Out = Collection_In.DefaultView.ToTable() 'Select columns Dim v As New DataView(Collection_Out) Collection_Out = v.ToTable(False, Column_Names_CSV.Split("","")) Wed, 10 Jan 2018 20:48:00 GMT John__Carter 2018-01-10T20:48:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59420#M13068 Just a quick question to anyone who has used the Filter Collection object, which is part of the standard Collection Manipulation Utility.   How does the syntax for the filter Input work. I have tried to just send variable, as the aim is to get all rows that contain this variable into a separate collection without tampering with the original collection and filtering seemed like an good solution, but without knowing how I filter, it's a bit of a non-starter.   Any help very much appreciated.   Thanks, Jordan Green Tue, 09 Jan 2018 21:46:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59420#M13068 JordanGreen 2018-01-09T21:46:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59421#M13069 Try something like ""FieldWithoutSpaces > 0 AND [Field With Spaces] = 'abc' Tue, 09 Jan 2018 22:26:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59421#M13069 John__Carter 2018-01-09T22:26:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59422#M13070 I tried using that syntax, which now means the object doesn't fail. However, it looks like now it just filters whole collections, rather than extracting the fields with the information that matches the filter.   Seems that the object filters whole collections rather than the fields within them. Wed, 10 Jan 2018 15:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59422#M13070 JordanGreen 2018-01-10T15:35:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59423#M13071 The Filter action is intended to return all rows matching the criteria. Your requirement seems to be one step more - to filter out unwanted rows and unwanted columns. The current collection utility doesn't have that functionality, but I think you can achieve what you want with another couple of lines of code. Something like this: 'Get filtered rows Collection_In.DefaultView.RowFilter = Filter Collection_Out = Collection_In.DefaultView.ToTable() 'Select columns Dim v As New DataView(Collection_Out) Collection_Out = v.ToTable(False, Column_Names_CSV.Split("","")) Wed, 10 Jan 2018 20:48:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59423#M13071 John__Carter 2018-01-10T20:48:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59424#M13072 'Get filtered rows Collection_In.DefaultView.RowFilter = Filter Collection_Out = Collection_In.DefaultView.ToTable() 'Select columns Dim v As New DataView(Collection_Out) Collection_Out = v.ToTable(False, Column_Names_CSV.Split("",""))   Wed, 10 Jan 2018 20:53:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59424#M13072 John__Carter 2018-01-10T20:53:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59425#M13073 Sorry - trying to post with line breaks! Wed, 10 Jan 2018 20:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59425#M13073 John__Carter 2018-01-10T20:54:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59426#M13074 I want to match anything that starts with abc , how do I use the expression. Like how we use wildcards ""abc""&""-## Fri, 12 Jan 2018 15:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59426#M13074 RekhaMurari 2018-01-12T15:22:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59427#M13075 use it - ""FieldName like abc* Fri, 19 Jan 2018 16:52:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59427#M13075 VenkatRamana 2018-01-19T16:52:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59428#M13076 VBO - collection manipulation Action - Filter collection Fri, 19 Jan 2018 16:53:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59428#M13076 VenkatRamana 2018-01-19T16:53:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59429#M13077 If we are checking for a specific fund we can use the below expression in the Filter Collection field. ""fund=' "" & ""ABC"" & "" ' ""   Does anyone knows how I can use OR in the above Filter to include Fund = ""XYZ"" as well? Wed, 31 Jan 2018 05:49:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59429#M13077 HarjyotMalik 2018-01-31T05:49:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59430#M13078 harjyot.malik, as John already noted in the second post, you can use logical operators. Yours would be: ""fund = 'ABC' OR fund = 'XYZ'"" Tested and worked. PS: I don't see why you would want to use the & to concatenate a String (only if you want to use data-items) Fri, 02 Feb 2018 14:04:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59430#M13078 Anonymous 2018-02-02T14:04:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59431#M13079 Hi, does anyone knows if you can user lower and upper case in the query? Thu, 22 Feb 2018 02:31:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59431#M13079 Milena_Martinel 2018-02-22T02:31:00Z https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59432#M13080 Can we filter all the distinct values in a column ? Thu, 19 Jul 2018 20:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Collection-Manipulation-Filter-Collection/m-p/59432#M13080 Prem_kumarR 2018-07-19T20:05:00Z