Format number to two digit

[zturaiki]

How to change the format for the field data format

From 1.2.1.45. To 01.02.01.45

I want to show the two digit ,,,,

[swuehl · Accepted solution]

If your string (1.2.1.45 is not a number) has always these four parts delimited by a dot, you could try like

=num(subfield('1.2.1.45','.',1),'00') & '.' &

num(subfield('1.2.1.45','.',2),'00') & '.' &

num(subfield('1.2.1.45','.',3),'00') & '.' &

num(subfield('1.2.1.45','.',4),'00')