TRIM

Removes leading and trailing whitespace or specified characters from a string.

Analyze Syntax

func.trim(<str>)

Analyze Examples

func.trim('  hello  ')

┌─────────┐
 'hello'  
└─────────┘

SQL Syntax

TRIM(<str>)

SQL Examples

SELECT TRIM('  hello  ');

┌───────┐
 hello  
└───────┘