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.

Intellectual Property Rights Notice | Technical Support