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

image

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

Hi @David_Oku

You can use Find Replace Activity

Refer the below link for that activity.

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

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like