CODEWITHSUNDEEP
blueprism
Eoin2211
Eoin2211

Reputation: 911

Blueprism Replace Characters in a collection

I have a collection with multiple columns. I want to search for any characters that have a fada/accent (eg. á) and replace them with the normal version of the character. So á would become a. This would be similar to ctrl f replace in excel.

Upvotes: 1

Views: 2089

Answers (2)

Eoin2211
Eoin2211

Reputation: 911

Ultimately I created an excel macro. The bot runs this macro and then reads the file into a collection

Upvotes: 1

Badda_Bing
Badda_Bing

Reputation: 640

Calculation stages have a "Replace" function available from the list under Functions>Text. To my knowledge, there is no standard feature available to do this once text is inside the collection. However, with this "Replace" function you should be able to have the fada/accents removed before the text goes into the Collection stage.

Upvotes: 1

Related Questions