Crystal String Formula

[Honyo]

Hi

I currently have a string field with a length of 9 characters. If the length is less than 9, then I need to add zeros to the front of data.
E.g. 45678 will become 000045678

I need the formula to get the length of the string and with anything less than 9, it adds the 0. Sounds easy, I know, but my brain has been twisted into knots with this.

Please help.

Regards
Honyo

 

[richmn]

Try something Like:

right("000000000" & yournumber,9)

Yournumber is assumed to be a chararter string (Or converted to one)..

Rich

 

[synapsevampire]

Try:

replicatestring("0",9-len(trim({table.field})))+{table.field}

-k