Fill Spaces w/ Asterisk

[csjoseph]

I'm creating a report for printing checks. In the amount field they want it always to be 12 spaces. If the amount is not twelve characters they want me to fill the leading spaces w/ asterisks. Does anyone know a quick way to do this?


Thanks.

Chris
IS Manager

 

[dgillz]

Write a formula to do this:

replicatestring("*",12-len(totext({YourField},2,"")))&totext({YourField},2,"")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kskid]

Try this

stringvar x := totext({table.number});

if length(x) > 11 then x
else
  replicatestring("*",12 - length(x)) + x

Cheers,
-LW