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) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| column_string | Y | string | Name of the column or string literal to be applied to the function |
Name of the column or string constant to be cleaned of whitespace.
'Hello, World').| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String literal or column reference | myColumn |