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


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