Builds a string of the specified length whose value consists of spaces.
Space ( n )
Argument |
Description |
---|---|
n |
A long whose value is the length of the string you want filled with spaces |
String. Returns a string filled with n spaces if it succeeds and the empty string (“”) if an error occurs.
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)