How to deal with condition(change "Man" to "1")


#1

I have excel file that contains datatable
and inside datatable , there is a data “man”

but i have to change all “man” to “1”
in this case, what kind of activities should i utilize??


#2

Hi @Seonyong

Use if condition
Row (“columnname”).Tostring.contains(“man”)
Use write range to iterate the rows to man
Thanks
Ashwin.S


#3

Hi @Seonyong,

you have 2 options.

1.use excel application scope and try to Ctrl+H find and replace method.

2.use read range activity get the data into datatable…loop through it check the value “men” matching update the value. and use write range to update the datatable

Regards,
Arivu


#4

Thanks for reply but actually i just started using UIPATH could u specifically mention how to make
"loop through it check the value men mathing update the value. and use write range to update the datatable part??


#5

Hi @Seonyong
Use read range activity and in properties create a datatable in datatable property
Use for each row activity and assign datatable value
Inside the body use if activity and apply the conditions above
Thanks
Ashwin.S


#6

thanks!!