Function LPad or RPad

[#1]

Hello,

I have to use Lpad function beacause i must convert a number with two characters (ex. 9 to 09).

I did not found it? Can Anyone help me, please?

Francesco

[abeyphilip]

Hi Francesco,

Please try this:

=num(9,'00')

regards,

Abey

[alexandros17 · Accepted solution]

if your field is myField and you need a string of 10 characters:

repeat('0', 10-len(myField)) & myField

Hope it helps

[#4]

Thank you Alessandro.

It is a correct solution.

Francesco

[alexandros17]

Can you please mark the answer as correct?

Thank you