Find and Replace functionality available?

[BhavyaTaneja]

Hi Experts,

How to perform find and replace functionality in Excel using Blue prism?

------------------------------
Bhavya Taneja
------------------------------

[ManpreetKaur1]

Hi @Bhavya Taneja,

Did you try code stage to achieve the functionality?
​

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

[BhavyaTaneja]

HI @ManpreetKaur1,

Thanks for the response. I don't have much idea on creation of different codes. Do you have any sample code available for achieving the functionality?
My process involves searching the value from a PDR report and based on the identified cell, the next steps needs to be performed and I am stuck due to this code. Can you please guide on the code stage?​

------------------------------
Bhavya Taneja
------------------------------

[ManpreetKaur1 · Accepted solution]

Hi @Bhavya Taneja,

Please refer the below video link for performing the find/search functionality in Blue Prism. 

https://www.youtube.com/watch?v=8L_UxfwYhw4​

You can create code for performing the replace functionality as well. It just needs small modification in the code (rather an addition of Replace function in the code) to achieve both find and replace functionality

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

[BhavyaTaneja]

Thanks a lot @ManpreetKaur1.
It really helped :)​

------------------------------
Bhavya Taneja
------------------------------

[ManpreetKaur1]

Glad it worked 🙂

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------