Add Characters in the beginning of the value

[KAPITYAN]

I have a field in the table that contains records that has '55' in the beginning. I want to have a calculation that once that record has a '55' at the beginning, I want to add '0000' before it. Like for example:

Record 1 has a value of 55556789 then I want the result to be 000055556789. 

 

Can you help me with this?

 

[NailDyanC]

Hello,

Can you please try this formula:

CASE WHEN

(Patindex('%33%', [@field:Century_code])) = 1

THEN
'0000'+[@field:Century_code]
ELSE
[@field:Century_code]
END

[Wikiwi]

If you want to use a triggered action you can create a setup just like below:

Trigger setup:

Output:

[cheonsa]

Hello!

For more details about calculations and Triggered Actions, you may refer to these links:

https://howto.caspio.com/tables-and-views/triggered-actions/

https://howto.caspio.com/function-reference/