![]() Check Code - Publish and Save Object and use it from Process to pass your collection and column name and return output collection. Row(column_name) = row(column_name).ToString().Replace(" ", "")ģ. Start Stage Input 1 as : Input Collection, Input 2 as : column Name End Stage Output: Output Collection as shown in below snip:įor Each row As DataRow In Input_Collection.Rows Hi Kummari Srikanth - You would just to need to tweak the code a bit - just add one more action - copy the same action and rename the action name and code stage name - Add one more input to determine the column where you want the space to be removed:ġ. I need this kind of filtering if anyone knows please help me. ![]() I want to filter the data in the collection by removing the spaces found in the collection data.įor example, I need to filter the name "ab c" or "a bc" by giving the filtering condition as "name ='abc'"įirst bot, should remove the spaces present in the input collection and then apply a filter. Mukesh Kumar - Senior Automation Developer Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help. Check Code - Publish and Save Object and use it from Process to pass your collection and return output collection.Īpply Filter Collection to get the result as you stated in your query above, let me know if you face any difficulties implementing this. Row(col.ColumnName) = row(col.ColumnName).ToString().Replace(" ", "")ģ. Add Code Stage and Set Input and Output : Write Code -įor Each Row as DataRow in Input_Collection.Rowsįor Each Col as DataColumn in Input_Collection.Columns Create a Custom Action in one of the Extended Collection Manipulation Object - Start Stage Input : Input Collection End Stage Output: Output Collection as shown in below snip:Ģ. Subject: Blue Prism Desktop is available now!Hi Kummari Srikanth, I would assume you have an extended object for Collection Manipulation - If not you can download one from Digital Exchange ()ġ.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |