To replace multiple strings in an excel cell

studio
variable
string

#1

I want to replace multiple strings. like i have some data in excel cell:
{Client_Id} (trans_Id} {User_Id} and i want to replace {Client_Id} with 1234, {trans_Id} with x23B and {User_Id} with @121bcd. Please suggest to perform this.

Thanks


#2

can you please try this,


#3

I saw that link there its given for different rows, i need to replace different values in same cell


#4

Try this out,

((variable1.replace("{Client_Id}",“1234”)).replace("(trans_Id}",“x23B”)).replace("{User_Id}","@121bcd")


#5

Thanks Buddy! It worked :slight_smile: