Adding the key number to the contacts number

[Feras95p]

Dear all,

I have a column which contains contacts number of 9 digits started from 5 I want to add to all of them the key number which is 966 

so the input number will be like this 549625709 I want the output to be like this 966549625709 any idea how it can be achieved?  

[atcodedog05 · Accepted solution]

Hi @Feras95p 

Here is how you can do it.

Workflow:

Hope this helps : )

[JaeLim]

Hi @Feras95p ,

One quick way to do this is by using the formula tool:
 

Do note as your are using an integer type input, you may need to first convert your input data type into "V_WString", otherwise  it would do a numeric addition instead.

[atcodedog05]

Happy to help : ) @Feras95p 

Cheers and have a nice day!