TRIM (Lakehouse v2)

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  │
└───────┘