SS&C Blue Prism Community

ZoltánTóth · 27-10-21

Dear Community Members!I have a collection with 10+ thousands rows and I need to rename some of its values. For example: "Cancellation Type A" should be "Cancellation", and "Cancellation Type B" should be "Cancellation" too. It is important that I am...

ZoltánTóth · 27-10-21

Our company's CRM system. It is not a public CRM system, it is built by the company.There is no way to extract it as a .csv, .xlsx. The only thing I can do is copy to clipboard and then paste it into a collection.------------------------------Zoltán ...

ZoltánTóth · 27-10-21

Thank you, Michael!It is almost what I need. As I mentioned above to use Excel VBO I have to write my collection into Excel, then run your code. Writing a collection into an Excel file is still very time consuming. I am looking for a solution that ca...

ZoltánTóth · 27-10-21

It sounds about right, but "Replace" requires perfect match, but I have dynamic text such as "Cancellation Type A", "Type B", "Type C" and so on. The only thing sure is "Cancellation", that is why I can't use "Replace".Regards,Zoli-------------------...

ZoltánTóth · 27-10-21

Yeah, the memory shortage is the reason why I am looking for a better solution. I have tried every other solution rather than loop stage, but writing the data to Excel and creating a pivot is almost as time consuming as the loop itself, so I am in th...

SS&C Blue Prism Community

User Statistics

User Activity

Find & Replace Value Within Collection

RE: Find & Replace Value Within Collection

RE: Find & Replace Value Within Collection

RE: Find & Replace Value Within Collection

RE: Find & Replace Value Within Collection