Excel Code Stage- Find and Replace

[JordanWain]

Hi,

Has anyone came across or used a Find and Replace excel code stage at all?

------------------------------
Jordan Wain
Blue Prism Developer
Shop Direct Group
Europe/London
------------------------------

[ewilson]

The link for the MS Excel VBO has been updated. You can access the VBO at the following link:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

[SalmanShaik1]

Hi Eric Wilson,
I tried to use replace worksheet action provided in excel vbo but its not working its replacing the entire worksheet with the new text value.
suppose i want to replace * with null in the worksheet then this action replaces all the cell values to null.
can you please provide a solution for this?

------------------------------
Salman Shaik
------------------------------

[ewilson]

Hello @Salman Shaik,

The functions worked as designed. The issue you're encountering is that "*" is a standard wildcard character in Excel as is "?".​ To search for the actual "*" character as opposed to using it as a wildcard you should try prepending a tilde "~" to the asterisks, so your search text will actually be "~*".

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------