Recent content by sunnysingh

Super!! Works like a charm now... This Filter utility seems underrated. We can use Like, Not Like and regular expressions as well. Do you know any source to refer where I can find more about the syntax and all the possible commands that can be used inside Filter text?

Thanks VJ and SG for the solutions. However, I tried both the solutions, syntax seems to be correct but the resulting collection is empty. I have checked the dataitem exists in column so should result in some data. Data Item is a number stored as text and the collection column is also a number...

Can some one please assist me with my query? Is it possible to use a data item in the filter collection, what will be the syntax? I want to filter a collection on the basis of data item "Number" containing a dynamic number.

Thanks VJ, Filter method works fine, is it possible to use a data item in the filter query, what will be the syntax? I want to filter a collection on the basis of data item "Number" containing a dynamic number.

Thanks for the reply VJ, as far as I know copy rows will copy x rows without any condition. I want to copy all the 50 columns in a new collection where col1 = 1 and col2 = 2, which should ideally copy row 1 and row 5 in a new collection with all the 50 columns. I hope I am able to put my query...

Coll1 contains 50 columns and 100 rows, I want to pick the complete row on the basis of condition that Coll1. Column2 & Coll1. Column3 & Coll1. Column4 matches a certain criteria, copy the complete row to a new Coll2 (blank). I know we can copy columns by explicitly mentioning them, but how can...