Whitespace Removal

The TRIM function was added to remove whitespace from a string. This function takes one parameter, a string, returns a copy of string provided with whitespace removed. Whitespace is defined as spaces, carriage return, newline, horizontal and vertical tabs.

Examples

TRIM("RESI    ")  // Removes spaces at the end of the string, resulting in a return value of "RESI"
TRIM("  
  RESI    
   
")    // Removes spaces at the beginning and end of the string, plus the carriage return, resulting in a return value of "RESI"