topic Find and Replace functionality available? in Product Forum

Find and Replace functionality available?

BhavyaTaneja — Sun, 21 Aug 2022 20:22:00 GMT

Hi Experts,

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

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

RE: Find and Replace functionality available?

ManpreetKaur1 — Sun, 21 Aug 2022 20:30:00 GMT

Hi @Bhavya Taneja,

Did you try code stage to achieve the functionality?

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

RE: Find and Replace functionality available?

BhavyaTaneja — Sun, 21 Aug 2022 20:38:00 GMT

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

RE: Find and Replace functionality available?

ManpreetKaur1 — Sun, 21 Aug 2022 20:46:00 GMT

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

RE: Find and Replace functionality available?

BhavyaTaneja — Sun, 21 Aug 2022 20:51:00 GMT

Thanks a lot @ManpreetKaur1.
It really helped :)

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

RE: Find and Replace functionality available?

ManpreetKaur1 — Mon, 12 Sep 2022 20:47:00 GMT

Glad it worked 🙂

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