You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
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
REPLACE pattern IN string WITH replacement REPLACE ( pattern , string , replacement )
Inputs
- pattern - An attribute of base type string or a string value. String must be a valid regular expression. The regular expressions used in several Blueriq Studio functions are common Java 1.4 expressions. For a complete documentation we refer to the online java documentation.
- string - An attribute of base type string or an expression that results in a string.
- replacement - An attribute of base type string or an expression that results in a string.
Return type
- string. If the pattern is not found, the original string is returned.
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 |
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.
EQUALS
EQUALS compares two strings and returns TRUE if and only if they are equal. This function is case sensitive.
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
string1 EQUALS string2 EQUALS ( string1 , string2 )
Inputs
- string1 - An attribute of base type string, an expression that results in a string or a constant string value.
- string2 - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- Boolean
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 |
Overview
Content Tools