transform value into char 4

Marcox28 · ‎04-05-2018

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 · ‎04-05-2018

You can also try the function FORMAT.

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

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ask4atish · ‎04-05-2018

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