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:

removewhitespace(MyName)

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

String literal example:

removewhitespace(' Hello, World ')

Output: Returns the string: Hello,World.

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