Whats the fastest way to perform a Simple business rule in a data table

[MasterOfLogic (David Oku)]

Hello guys, thanks for always helping. i have this data table with a column called “REFERENCE”. i am looking for the fastest way to perform this business rule in it. on column “REFERENCE” every reference that has “T2020061905233390” should be corrected to “BOT2020061905233390”, but if it already has “BOT2020061905233390” it should not do anything in it. what i am simply trying to do is correct “T” with “BOT” in the references

Thanks guys

[Pratik_Wavhal]

Hi @MasterOfLogic

You can use Find Replace Activity

Refer the below link for that activity.

BalaReva.Excel.Activities

Hi @Rajvir, Thank you @Rajvir to look about my package.I have developed the package to the UiPath users. The BalaReva.Excel.Activities are not provided by UiPath . As of now the activities are reached the more downloads that you can see in the below. [image] You can get to know about the activities and reviews in the below link. Note: If you have any doubts about the package and activities , you can ping me here. Thank you Balamurugan.S

Hope this would solve your issue
Mark as solution and like it.

Happy Automation

Best Regards
Er Pratik Wavhal