LTRIM

Learn how to use the LTRIM string function in PlaidCloud Lakehouse. Removes all occurrences of any character present in the specified trim string from the...

Removes all occurrences of any character present in the specified trim string from the left side of the string.

See also:

Analyze Syntax

func.ltrim(<string>, <trim_string>)

Analyze Examples

func.ltrim('xxdatabend', 'x')
┌────────────────────────────────┐
│ func.ltrim('xxdatabend', 'x')  │
├────────────────────────────────┤
│ databend                       │
└────────────────────────────────┘

SQL Syntax

LTRIM(<string>, <trim_string>)

SQL Examples

SELECT LTRIM('xxdatabend', 'xx'), LTRIM('xxdatabend', 'xy');

┌───────────────────────────────────────────────────────┐
│ ltrim('xxdatabend', 'xx') │ ltrim('xxdatabend', 'xy') │
├───────────────────────────┼───────────────────────────┤
│ databend                  │ databend                  │
└───────────────────────────────────────────────────────┘