Product SiteDocumentation Site

7.4.59. SPACE


>>-SPACE(string--+--------------------+--)---------------------><
                 +-,--+---+--+------+-+
                      +-n-+  +-,pad-+

Returns the whitespace-delimited words in string with n pad characters between each word. If you specify n, it must be a positive whole number or zero. If it is 0, all whitespace characters are removed. Leading and trailing whitespace characters are always removed. The default for n is 1, and the default pad character is a blank.
Here are some examples:

Example 7.73. Builtin function SPACE

SPACE("abc  def  ")          ->    "abc def"
SPACE("  abc def",3)         ->    "abc   def"
SPACE("abc  def  ",1)        ->    "abc def"
SPACE("abc  def  ",0)        ->    "abcdef"
SPACE("abc  def  ",2,"+")    ->    "abc++def"