Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Removes specified characters from the start of a string.
Syntax
ltrim(<string> [, characters])
Arguments
Required
<string>: The string to trim.
Optional
characters: The characters to remove. Defaults to space.
Returns
Returns a text value with specified characters removed from the start.
Considerations
- Removes individual characters from the set, not as a substring pattern.
- Continues removing until it encounters a character not in the set.
Examples
Left Trim
Remove characters from the start of a string.
SELECT ltrim('zzzytest', 'xyz') AS result;
Returns 'test'.