Space()

<< 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.

 

Original Enterprise 01