cancel
Showing results for 
Search instead for 
Did you mean: 

Find and Replace functionality available?

BhavyaTaneja
Level 3
Hi Experts,

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

------------------------------
Bhavya Taneja
------------------------------
1 BEST ANSWER

Helpful Answers

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
------------------------------

View answer in original post

5 REPLIES 5

ManpreetKaur1
Level 8
Hi @Bhavya Taneja,

Did you try code stage to achieve the functionality?


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

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
------------------------------

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
------------------------------

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

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

Glad it worked 🙂

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