Remove

In this document, you’ll learn how to use the Remove function in Astera Dataprep to clean unwanted characters from your data.   

1. To begin, click on the Cleanse option in the toolbar and select Remove from the drop-down.  

1. This will open the Recipe Configuration – Remove panel.

1. In this panel, you’ll configure the following options:

• Apply to entire dataset: The changes will be applied to the entire dataset.

• Apply to specific column(s): Allows you to apply changes to specific columns.

Under the Remove section, you can choose what to remove:

• All whitespaces

• Leading and trailing whitespaces

• Tabs and line breaks

• Duplicate whitespaces

• Letters

• Digits

• Punctuations

• Specified characters – You can enter one or more characters (separated by commas) to be removed.

1. Once you’re done, click Apply. For example, in our use case the Grid will show that all whitespaces and hyphens ("-") have been removed from the ShipPostalCode column.

1. Alternatively, you can right-click on a column in the Grid and go to Cleanse > Remove. The same configuration panel will appear with the column already selected. Make any changes you need and click Apply to clean the data.