Skip to main content

ltrim

Description

Removes whitespace from the start of a string while leaving the end unchanged.

Syntax

Like many functions in DataPrime, ltrim supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

ltrim(value: string): string

Arguments

NameTypeRequiredDescription
valuestringtrueThe string to trim

Example

Clean up an extracted username

{
"username": " SyntaxTerror"
}

Use ltrim to remove the unwanted space:

Example query

create trimmed_user from ltrim(username)

Example output

{
"username": " SyntaxTerror",
"trimmed_user": "SyntaxTerror"
}
Was this page helpful?