Trim text | TEXT_TRIM

Syntax

TEXT_TRIM( [value] )

Parameters

value
The TEXT to trim. If it is not a TEXT value, it will be converted to one with the STRING operation.

Return Value

A new TEXT with all the white-space characters removed from the start and end of VALUE.

Description

Remove white-space from the start and end of a TEXT.

Examples

TEXT_TRIM("  four score and seven years ") # returns "four score and seven years"

TEXT_TRIM("") # returns ""

TEXT_TRIM(null) # returns ""

TEXT_TRIM(1234) # returns "1234"