LTRIM

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Removes specified characters from the start of a string.

1ltrim(<string> [, characters])

• <string>: The string to trim.

• characters: The characters to remove. Defaults to space.

Returns a text value with specified characters removed from the start.

• Removes individual characters from the set, not as a substring pattern.
• Continues removing until it encounters a character not in the set.

Remove characters from the start of a string.

1SELECT ltrim('zzzytest', 'xyz') AS result;

Returns 'test'.

• String Types