Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite

REPLACE

The REPLACE function replaces


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 )



Inputs
  • pattern
 
  • - 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
  • Encore 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

ExpressionResultType
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 Boxtypenote
Info

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

.

Back to top

Panel
bgColorwhite

EQUALS

EQUALS compares two strings and returns TRUE if and only if they are equal. This function is case sensitive.

UI Text Box
typewarning

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

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

    ExpressionResultTypeNote"hello" EQUALS "hello"TRUEBooleanEQUALS ( "hello" , "Hello" )FALSEBooleanFALSE because EQUALS is case sensitive"hello" EQUALS "hello "FALSEBooleanFALSE because of trailing spaceEQUALS ( "" , "" )TRUEBoolean



    Back to top