Data Cleansing Tool

Select the fields to cleanse using the configuration options below. All options, except for Replace Nulls with 0, apply to string data types. To specify different options for different fields, use multiple Data Cleansing tools in your workflow.

Replace nulls with blanks in string Data Types. Replace nulls with 0 in numeric data types. Both options are selected by default. To replace nulls with values other than blanks or 0, use the Imputation Tool.

• Leading and Trailing Whitespace is selected by default.
• Tabs, Line Breaks, and Duplicate Whitespace replaces any occurrence of whitespace with a single space, including line endings, tabs, multiple spaces, and other consecutive whitespace.
• All Whitespace removes any occurence of whitespace.
• Letters removes all letters. This includes letters outside of the Latin alphabet.

  A b Z À é ö

• Numbers removes all numbers.
• Punctuation removes the following characters:

  ! " # $ % & ' ( ) * + , \ - . / : ; < = > ? @ [ / ] ^ _ ` { | } ~

Select an option to change the capitalization of string data types:

• Upper Case capitalizes all letters in a string.
• Lower Case converts all letters in a string to lowercase.
• Title Case capitalizes the first letter of all words in a string.