Removing Multiple Spaces from Data in all columns

Solved!
tgb417
Removing Multiple Spaces from Data in all columns

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 columnsRemove 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

--Tom
0 Kudos
2 Solutions
tgb417
Author

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

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

 

--Tom

View solution in original post

0 Kudos
tgb417
Author

The regular expression should actually be

(\s\s+)

not what is shown in the image above.

--Tom

View solution in original post

2 Replies
tgb417
Author

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

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

 

--Tom
0 Kudos
tgb417
Author

The regular expression should actually be

(\s\s+)

not what is shown in the image above.

--Tom