Removes all whitespace from a string, including leading and trailing whitespace and all whitespace within the string.

Spacing between words is removed.

Column reference example:

derive type:single value:REMOVEWHITESPACE(MyName)

Output: The value of the MyName column value with all whitespace removed. 

String literal example:

derive type:single value:REMOVEWHITESPACE(' Hello, World ')

Output: The string Hello,World is written to the new column.

derive type:single value:REMOVEWHITESPACE(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

column_string

Name of the column or string constant to be cleaned of whitespace.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - String cleanup functions together