Remove the leading 0

[Kuroshi]

I'm trying to get a phone number including its international dialing code.  '[@cbParamVirtual3]'+RIGHT('[@cbParamVirtual4]',9) ...the first parameter takes the dialing code, and the last one takes the 9 digits from the right. but the problem I have encountered is that not all countries have 9 digits after the 0. if the first zero isn't written we just take the number as is.

[Barbie]

Hi Batchini,

you can use this instead: 

CASE WHEN LEFT([@field:Phonenumber], 1) = '0'
THEN REPLACE(LTRIM(REPLACE([@field:Phonenumber], '0', ' ')), ' ', '0')
ELSE [@field:Phonenumber]
END
 

-Barbie

[cheonsa]

Hello!

For additional information regarding formula, you can check this link: https://howto.caspio.com/function-reference/