Collapse Spaces

Collapse multiple consecutive spaces into one space.

Collapse Spaces

1. You can either:

• • right-click on a Text field

  • click the drop down of a Text field

then select Clean > Collapse Spaces in the context menu that displays.

All the spaces are collapsed.

Example: Description is the original column and Collapse Result shows the collapsed data.