<< Click to Display Table of Contents >> Navigation: Available Functions > Space() |
Syntax
Space( <NumericValue> )
Purpose
To return <NumericValue> space characters.
Parameters
<NumericValue> is the number of spaces you want.
Returns
A Character value.
Usage
Designed for use in a report format definition, selection, or export, the "Space()" function is used to generate any number of spaces. This can be useful when creating complex report column expressions involving more than one field. It can be used to force a set number of spaces to be present anywhere within a report.
Examples
You wish to combine the .Address. and .City. fields within a single report column, and you wish the .Address. field to always be followed by ten spaces, regardless of the respective lengths of the current .Address. and .City. fields. This would be accomplished by entering the following expression for the column Field Name/Expression:
.Address. + Space( 10 ) + .City.