Is there a function in Crystal which serves the purpose of lpad in Oracle?
lpad(x , 8 , '0') would return x always as a string of 8 characters even if it's original length is less. 0 will be appended to it's left if it is of shorter lenght.
totext({table.number},replicatestring('0',8))
or even replace '8' with a global variable in order to be able to easily change the format but altering the variable's value, especially when using various formula fields that contain this expression.
Thanks to you both. The field is a string, I had to use only part of it then convert it to number then back to string.
totext(tonumber(right({Authorization No},8)),"00000000")
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.