Even though the problem has been solved. I would recommend to use a regular expression for these types of replacements. This way you can remove an arbitary amount of whitespaces.
Use this in a String Manipulation Node and it should solve the problem nicely: strip(regexReplace($column1$,"\\s{2,}" ," "))
The \\s stands for whitespaces and the {2,} means two or more.
22 Likes