Product Site

7.4.60. SPACE

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"