EXAMPLE - String Cleanup Functions

The following example demonstrates functions that can be used to clean up strings. These functions include the following:

• TRIM - remove leading and trailing whitespace. See TRIM Function.
• REMOVEWHITESPACE - remove leading and trailing whitespace and all whitespace in between. See REMOVEWHITESPACE Function.
• REMOVESYMBOLS - remove all characters that are not alpha-numeric or whitespace. See REMOVESYMBOLS Function.

Source:

In the following (space) and (tab) indicate space keys and tabs, respectively. Carriage return and newline characters are also supported by whitespace functions.

Transform:

The following transforms generate new columns using each of the string cleanup functions:

derive type:single value: TRIM(source) as: 'trim_source'

derive type:single value: REMOVEWHITESPACE(source) as: 'removewhitespace_source'

derive type:single value: REMOVESYMBOLS(source) as: 'removesymbols_source'

Results: