TRIM(S)

 

Description

This function returns the string formed by removing leading, trailing, and consecutive embedded spaces from string S.

 

Parameters

 

S

A string value.

 

Examples

 

TRIM(" Alpha Beta Gamma ") = "Alpha Beta Gamma"

 

TRIM(R5) = "There's no place like home."

Where R5 = "There's no place like home.".