SPLIT
returns
Returns a multivalued string attribute containing every substring that is delimited by the given pattern.
Syntax Code Block |
---|
SPLIT string ON pattern
SPLIT ( string , pattern ) |
Inputs |
An - An attribute of base type string or a string value. String must be a valid regular expression.
|
The - The regular expressions used in several Blueriq
|
Studio functions
Return type
Example Expression | Result | Type |
---|
SPLIT "Hello world" ON "o" | [ "Hell" , " w" , "rld" ] | String (multivalued) | SPLIT ( "Hello world" , "a" ) | [ "Hello world" ] | String (multivalued) | SPLIT "Hello" ON "o" | [ "Hell" ] | String (multivalued) | SPLIT ( "ooo" , "o" ) | [ ] | String (multivalued) | SPLIT ( "bot" , "o" ) | [ "b" , "t" ] | String (multivalued) | SPLIT ( "boot" , "o" ) | [ "b" , "", "t" ] | String (multivalued) | SPLIT ( "booot" , "o" ) | [ "b" , "", "t" ] | String (multivalued) | To remove dots from a string in combination with the JOIN function: | JOIN ( SPLIT ( "H.E.L.L.O" , "\.") , "" ) | "HELLO" | String |
|
UI Text Box |
---|
|
Info |
---|
If you use the SPLIT in a default expression on an multivalued attribute, please note that the result will be stored as collection, meaning that all duplicates will be removed. To illustrate this: suppose we have an attribute Test.Splitted (multivalued), which has the default expression SPLIT ( "H.E.L.L.O" , "\.") . The result of the expression JOIN ( Test.Splitted , "" ) = "HELO" instead of "HELLO" as in the last example. |
|
Panel |
---|
|
REPLACE
The REPLACE
function replaces every occurrence of a string pattern within another string with a provided replacement string. The function is case-sensitive.
Syntax
Code Block |
---|
REPLACE pattern IN string WITH replacement
REPLACE ( pattern , string , replacement ) |
InputsReturn type
Examples
Expression | Result | Type |
---|
REPLACE ":" IN "hello:world:example" WITH " " | "hello world example" | String |
REPLACE ( "o" , "hello world" , "a" ) | "hella warld" | String |
REPLACE ( "O" , "hello world" , "a" ) | "hello world" | String |
REPLACE "\s" IN "hello world example" WITH "" | "helloworldexample" | String |
REPLACE ( "\d{2}" , "hello1 world22 example333" , "@" ) | "hello1 world@ example@3" | String |
REPLACE ( "" , "hello world" , " " ) | " h e l l o w o r l d " | String |
REPLACE "\s" IN "hello world example" WITH "\s" | "hello\sworld\sexample" | String |
UI Text Box |
---|
|
The first argument is a pattern (regular expression) and can therefore contain specials like \s for a space. The second and third arguments are strings or expressions, so \s will result in \s. |
Panel |
---|
|
EQUALS
EQUALS
compares two strings and returns TRUE if and only if they are equal. This function is case sensitive.
UI Text Box |
---|
|
Only use this function if you need a case sensitive comparison of two strings. If you want to compare strings case insensitive, use the '=' operator instead. |
Syntax
Code Block |
---|
string1 EQUALS string2
EQUALS ( string1 , string2 ) |
Inputs
Return type
Example
Expression | Result | Type | Note |
---|
"hello" EQUALS "hello" | TRUE | Boolean | EQUALS ( "hello" , "Hello" ) | FALSE | Boolean | FALSE because EQUALS is case sensitive |
"hello" EQUALS "hello " | FALSE | Boolean | FALSE because of trailing space |
EQUALS ( "" , "" ) | TRUE | Boolean