Hello Community, i'm facing an issue filtering a huge (about 4k rows) collection of strings: sometimes the field value is a string with apostrophe (example: "del'aqu"), and i need to filter the collection (like strategy) according that value, which is previously stored in a string data item; i...
I am having issues around [Utility - Collection Manipulation - Filter Collection]
I have a Get Files action which gets all the files from a particular folder and outputs them into a collection in Blue Prism (there are 14 .txt files)
I then use the Filter Collection Object to filter...
I've read a csv file as a collection and I'm trying to mimic the action of a macro in blue prism, I have sorted the data accordingly and I am now looking to filter the data point (which happens to be datetime) by the " " space separating the date and time.
I have this so far...
I have been successfully filtering a collection using a data item as a wildcard, but I recently ran into an issue where the name in the data item included a ' and it's caused an error.
Example: Data Item Name = L'Oreal
Action: Filter Collection
Filter: "Name LIKE '" & "*" & [Data Name] & "*"&...
This sounds to me like it should be easy but I haven't figured it out yet.
I have a collection of excel files within BP and I want to filter them because for some reason once I get them inside BP, some of the files are duplicated; Fortunately, the duplicates all add a "~" to the start of their...
Hi guys, How can I filter a column with single quote?
For example: "[Column 1] LIKE ' 'F* ' "
(Internal : Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'F' operator.)
I have requirement to filter the records on the basis of one criteria and after comparing both the sheets, paste the records into another sheet.
In both the excels the templates are same and there first three rows and last row are merge rows.
What i did: After perform all my bot functionality...
I tried in Utility - Collection Manipulation -> Filter Collection, Filter "Col like '0*'", this works...
But I want to filter the column where the value starts with a number. Something like "Col like '[0-9]*'", is it achievable?
I have a collection with one column data as below: (Collection In = Lines)
Field Name = Line (Text)
Name Microsoft OneDrive for Business
Publisher Microsoft Corporation
I am reading a text file, always containing a header and footer line and some error entries. I already have all single lines available in a collection (see screenshot - Split lines). Now I want to filter out the header and footer and separate the lines , in the end I want to have all...