transform value into char 4

[Marcox28]

Hi I have values ​​in a table that are char 3 or 2, how can I change in char 4?

example : 170 I want to turn it into 0170

[v-jiascu-msft]

Hi @Marcox28,

You can also try the function FORMAT.

Column = FORMAT([Column1], "0000")

Best Regards,

Dale

[ask4atish]

Hi,

As per your question your values are either of 2 or 3 characters. You can use concatenate function. create a column where you should check length of your character. If it is less than 3 then concatenate it with "00" and if length of character =3 then concatenate it with "0".

check the below expression if this works as per your requirements.

column = if(LEN(your field)<3,CONCATENATE("00",your field),if(LEN(your field)=3,CONCATENATE("0",your field))). Check teh screenshot below.

Thanks,

Atish