TRIM

Removes characters from the beginning and end of a string.

This function corresponds to the trim(X, Y) function in SQLite.

• If only one argument column is provided, it removes leading and trailing spaces from the string.

• If the optional trimChars argument is provided, it removes any character present in trimChars from both the beginning and the end of the string in column.

If the input column is not a string, it is first coerced into one. A NULL input results in a NULL output.

Example

// Removes leading and trailing spaces: trim('  hello  ') -> 'hello'
select(TRIM(StringLiteral("  hello  "))).execute()

// Removes specified leading/trailing characters: trim('**--hello--**', '*-') -> 'hello'
select(TRIM(StringLiteral("**--hello--**"), "*-")).execute()

// Using a column
select(TRIM(Users.username)).from(Users)

Parameters

See also