add special numbers in the beginning of cells

[febriansyah28]

How can i add more numbers in the first cell like adding “63” to the cells which started with “8” in the cells. For example

from
832118744833
want to change to
62832118744833

thank you

[tqAkshay95]

Hello @febriansyah28,

You can use the String Manipulation node and write an expression like:

regexReplace($column1$, “^8”, “63$0”)

for your reference. Also, an image is attached:

Output:

[tqAkshay95]

@febriansyah28 ,

if you have got the solution, please mark it with a green tick