You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
SUBSTRING AFTER
SUBSTRING_AFTER returns the end of a given string after the first occurrence of substring, or an empty string if substring is not found.
Syntax
SUBSTRING AFTER substring IN string SUBSTRING_AFTER ( 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 AFTER ":" IN "hello:world" | "world" | String |
| SUBSTRING_AFTER ( "hello:world:all" , ":" ) | "world:all" | String |
| SUBSTRING AFTER "a" IN "hello:world" | "" | String |
| SUBSTRING_AFTER ( "" , "hello" ) | "" | String |
| SUBSTRING_AFTER ( "hello" , "" ) | "hello" | String |
Overview
Content Tools