Removing Multiple Spaces from Data in all columns

[tgb417]

One of the great features of DSS is that you can trim the leading and trailing spaces from all of the data in all of your columns with one visual recipe Step.  Very Cool.

Remove Leading and Trailing spaces from all columns

I was then trying to figure out how to clean up all the white space. Any ideas?

---

Operating system used: Ubuntu 18.04 - WSL2 - Windows 11

[tgb417 · Accepted solution]

I think I have a way.  Anyone got a better way?

Visual Recipe Step to replace multiple spaces with a single space in all columns

[tgb417 · Accepted solution]

I think I have a way.  Anyone got a better way?

Visual Recipe Step to replace multiple spaces with a single space in all columns

[tgb417 · Accepted solution]

The regular expression should actually be

(\s\s+)

not what is shown in the image above.