You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
SUBSTRING BEFORE
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
| Expression | Result | Type |
|---|---|---|
| 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 |
Overview
Content Tools