btrim function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above

Returns str with leading and trailing characters removed.

Syntax 

btrim( str [, trimStr ] )

Arguments

  • str: A STRING expression to be trimmed.

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

Returns

A STRING.

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

Examples 

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

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