Crystal function similar to Oracle's LPad? 2

[darwin101]

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.

Thanks

 

[lbass]

You could use:

totext({table.number},"00000000")

This would create an 8-digit string with zero's padding the number to the left. Adjust the number of zero's to control the length of the string.

-LB

 

[crystalvictim]

You could also use:

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.

 

[darwin101]

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")