`btrim` function

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above

Returns str with leading and trailing characters removed.

Syntax

btrim( str [, trimStr ] )

str: A STRING expression to be trimmed.
trimStr: An optional STRING expression with characters to be trimmed. The default is a space character.

A STRING.

The function removes any leading and trailing characters within trimStr from str.

SQL
> SELECT 'X' || btrim('    SparkSQL   ') || 'X';
 XSparkSQLX

> SELECT btrim('abcaabaSparkSQLabcaaba', 'abc');
 SparkSQL