SUBSTRING BEFORE


Returns the start of a given string before the first occurrence of substring, or an empty string if substring is not found


Syntax

SUBSTRING BEFORE substring IN string
SUBSTRING_BEFORE ( string , substring )


Inputs

  • string - An attribute of base type string, an expression that results in a string or a constant string value.
  • substring - An attribute of base type string, an expression that results in a string or a constant string value.


Return type

  • string


Example

ExpressionResultType
SUBSTRING BEFORE ":" IN "hello:world""hello"String
SUBSTRING_BEFORE ( "hello:world" , ":" )"hello"String

SUBSTRING_BEFORE ( "hello:world:all" , ":" )

"hello"String
SUBSTRING_BEFORE ( "hello:world" , "h" )""String
SUBSTRING BEFORE "a" IN "hello:world"""String
SUBSTRING_BEFORE ( "" , "hello" )""String
SUBSTRING_BEFORE ( "hello" , "" )""String