Space

Description

Builds a string of the specified length whose value consists of spaces.

Syntax

Space ( n )

Argument

Description

n

A long whose value is the length of the string you want filled with spaces

Returns

String. Returns a string filled with n spaces if it succeeds and the empty string (“”) if an error occurs.

Examples

Example 1

This expression for a computed field returns 10 spaces in the computed field if the value of the rating column is Top Secret; otherwise, it returns the value in rating:

If(rating = "Top Secret", Space(10), rating)

See also