I have an expression which is supposed to put Leading zeros to Norwegian zip codes. The zip code should always be 4 digits. This works with PSM version 5 but I can't get it to work with version 6. The expression is: IF(LEN( [Postnr])= 2,"00" &

pfriden,

Did you try changing your variable's type to Text? Go to the variables list(Window->Variables if you don't see it), select the variable that contains the zip code, and in it's properties(Window->Properties), change it's type to Text.

Let us know if that works!

Regards,
Rapha

Thank you! That made the difference. I've tried to do the formatting in Excel but that didn't work.
Regards
/Per

You can also use RIGHT("000" & [postnr],4) - also works if there's 1 digit in the database.

Thanks! I had never used the Function "Right" in that way. That is much easier. The database included a one digit zip code so I had already extended my expression. This one I can remeber.
/Per

I find using "COUNTER([Variable],[Variable],0,6,True)" works well. You can adjust the amount of leading zeros without the need to know the length of the field/variable.