||Re: add leading zero to stuff number to 6 digits
Mervyn Bick <email@example.com>
||Sat, 21 Apr 2018 14:55:10 +0200
On 2018-04-21 2:30 PM, Keith wrote:
> Any function that I can use to expand number to 6 digits by addint leading zero.
> Thx a lot!
You can add leading zeros to a number if it's digits are stored as
a = '6'
a = right('000000'+a,6)
b = '13'
b = right('000000'+b,6)
If the number is stored as a numeric value you can convert it to
characters by using str(). See the help file for an explanation of the
arguments which are passed to the function.
c = 6
c = str(c,6,0,'0')
d = 13
d = str(d,6,0,'0')