Trimming White Spaces

Tim white spaces to save space for your dataset.

Trim the white spaces at the beginning and end of a string to ensure that their identical values do not differ by white space only, which can be quite tricky to detect, thus making your data consistent and reduce the size of your dataset.

To trim all the leading and trailing white spaces in a data table in one go:

On the toolbar, click Data > Edit columns > Trim all the leading and trailing white spaces.