Overview

The code

      
/**
 * It replace all new lines and multiple spaces (including tab spaces) by a single space
 * @param {string } text
 * @return {string} a new cleaned string
 */
function cleanUpSpaces(text) {
    if (!text) {
        return text;
    }
    // \s{2,} matches any white space (length >= 2) character (equal to [\r\n\t\f\v ])
    return text.replace(/\s{2,}/g, ' ');
};

Output example

      
// given
`SELECT *
            FROM account        WHERE id =    1234`

// output
SELECT * FROM account WHERE id = 1234