Concatenate strings in Mapper snap

[darshthakkar]

I want to utilize the functionality of mapper snap to prefix my value with a static string, then concatenate with other variables and again concatenate with a static string.

I’m able to do the concatenation part however I cannot prefix the string. Any suggestions please?
Thanking you in advance for your time.

[bojanvelevski]

Hey @darshthakkar,

You can do the prefixing with concatenation. Ex.: "00"+$ID+"00"

Let me know if this is what you need.

[darshthakkar]

I tried the above approach and somehow it didn’t work for me. I will try a second time and keep you posted…

[bojanvelevski · Accepted solution]

If your column is of number type than yes, it won’t work. You’ll have to try something like this:

"00"+$ID.toString()+"00"

[darshthakkar]

Thanks a TON @bojanvelevski for providing me the right direction. I did mess up with the " " while concatenating variables and yes one of them was a number indeed.

Remember, you suggested me to parseInt($ID) for sort previously? It’s working now so THANK YOU 😍 :smiling_face_with_three_hearts: