Category: Text function

This function removes repeating whitespace from text, reducing it to a single space. Note that line breaks and other special characters are not counted as whitespace.

Return value type: Text

There needs to be two or more repeated spaces in text for this function to have an effect. If text is a string with no spaces or only single spaces within the text no change to text will occur.

As this function reduces repeated spaces to a single space, it cannot be used to completely remove leading and trailing whitespace. For that, use the Trim(text) function.

compact( 'A           Z') = 'A Z'
compact( 'A       N       Z') = 'A N Z'
len(compact( 'A           Z')) = 3

• Trim(text)
• Replace(text, old_string, new_string)