Replace excel function

Hello everyone,
I want to replace a string in excel with another string.
I will use the new table to automate a web app
How to do that with uipath ?

Hi there @Youssef

Seems like there is a disconnect in your second and third sentence. Please provide more context and more details you provide you can expect the solution to be more precise:)

Regards

1 Like

I am using an excel file data to automate a web app.
The column name contains this word " L’Assuré"
I want to replace the word “L’Assuré” with “L’Assuré” before reading the data from excel.
got it ?

Fine
–use excel application scope and pass the file path as input
–use read range activity and get the output with a variable of type datatable named out_dt
–use a assign activity like this
out_dt.Columns(“L’Assuré”).ColumnName = "the name you want"

But one thing, here in this statement
The column name contains this word " L’Assuré"
I want to replace the word “L’Assuré” with “L’Assuré”
both looks same, fine you can replace the name of the column as suggested above

Kindly try this and let know for any queries
Cheers @Youssef

Sorry I want to replace “L’Assuré” with " Lapos&Assuré"

Fine you can mention that as you want
Kindly try and let know
Cheers @Youssef

1 Like

How about replace rows value under column?

well you can do like this with a assign activity
row(“yourcolumnname”) = "value you want to replace"
Cheers @Youssef

I if rows contains “x” then replace “x” with new value

use a if condition like this
row(“columnname”).ToString.Contains(“x”)
if this condition gets passed it will go to THEN part of if condition where you can mention like this
row(“Columnname”) = "x"
If not it will go to ELSE part and go to the next row in the datatable
Cheers @Youssef

2 Likes

still any issues buddy @Youssef

1 Like