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.
© 2024 Altair Engineering Inc. All Rights Reserved.