The Clean data step removes leading or trailing spaces and other unwanted characters (letters, numbers, or punctuation) from any rows of data you'd like.

Clean data

Input/output

Our input data has a column of "Text" with various leading trailing spaces and punctuations.



By using the Clean data step, we can easily remove spaces to clean up the "Text" column.



Settings

When you first connect data into this step, Pick the dataset and columns(s) to clean and your desired options to clean up (like "Remove all spaces").

The available cleaning options are:

Remove all spaces
Remove leading spaces
Remove trailing spaces
Remove all punctuations
Remove all characters
Remove all numbers
Remove Special Characters

You can combine the cleaning options if needed.

In our above screenshots, we selected the "Text" column to apply our cleaning rules to and selected three cleaning options: Remove leading spaces , Remove trailing spaces and Remove all punctuations. As seen in the screenshot below, this cleaned up varying leading, trailing spaces and punctuations that were in the "Text" column's rows.

Was this article helpful?
Cancel
Thank you!