Remove Consecutive Spaces (Collapse)

Description

Trims to a single space any sequence of two or more consecutive spaces within a string. It also removes any leading or trailing spaces from the string.

INPUT/Output DATA TYPE

Input	Output
text	text

 

example

In this example, Idiom is the original column and Idiom - Clean shows the new values with all spaces collapsed.