How can I print a character

[mrfritz44]

Is there a function to print a specified number of charaters? For example, I need append spaces to a field based on the length of that field. I suppose it would go something like this:

PrintSpecifiedCharacterFunction((10-Len(Field))," ")

In my example, I would want to fill my dynamically lengthed field with up to 10 spaces. My end result would always be a field length of 10, regardless of actual data or a series of 10 spaces.

There must be a function to do this.

Thanks,

Fred

 

[PHV]

Have a look at the Space and the String functions.


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mrfritz44]

Space() did the trick......actually

Space(10-nz(Len(Field)))

did the trick. I love null values!

Thanks for the tip.

Fred