Page History
...
LAST returns the last character(s) of a string, based on the number of characters you specify.
Syntax
Code Block |
---|
LAST integer CHARACTERS OF string LAST CHARACTER OF string |
- integer - A positive integer value. This can be either an attribute of base type integer, an expression that results in an integer or a constant integer value. LAST CHARACTER OF can be used to retrieve only the last character of the string.
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- string
UI Text Box | ||
---|---|---|
| ||
If you prefer a functional syntax, you can use the STR_BACK ( string, integer ) function. Example: STR_BACK("Blueriq", 3) = "riq" |
Examples
If File.name
is an attribute of base type string with value "Thisfile_1.doc" and the integer attribute File.extension
has value 3 then:
LAST File.extension CHARACTERS OF File.name = "doc"
LAST CHARACTER OF File.name = "c"
LAST 4 CHARACTERS OF "pieceofcake" = "cake"
LENGTH
LENGTH
returns the length of a string
Syntax
Code Block |
---|
LENGTH ( string ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- integer
UI Text Box | ||
---|---|---|
| ||
Spaces at the start of the end of the string are counted as well, the string is not trimmed. |
Example
LENGTH( "Blueriq" ) = 7
LENGTH( " Blueriq " ) = 9
LENGTH( ? ) = ?
UPPER
UPPER
returns a string with all characters in uppercase
Syntax
Code Block |
---|
UPPER ( string ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- string
Example
UPPER( "hello" ) = "HELLO"
UPPER( "WORLD" ) = "WORLD"
UPPER( "hello world " ) = "HELLO WORLD "
UPPER( " hELLo " ) = " HELLO "
UPPER( ? ) = ?
LOWER
LOWER
returns a string with all characters in lowercase
Syntax
Code Block |
---|
LOWER ( string ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- string
Example
LOWER( "hello" ) = "hello"
LOWER( "WORLD" ) = "world"
LOWER( "Hello World " ) = "hello world "
LOWER( " hELLo " ) = " hello "
LOWER( ? ) = ?
CAPITALIZE
CAPITALIZE
returns a string with the first character uppercased
Syntax
Code Block |
---|
CAPITALIZE ( string ) CAPITALIZE ( string, lowerTheRest ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
- lowerTheRest - An attribute of base type boolean, an expression that results in a boolean or a constant boolean value, indicating that the other characters need to be lowercased. This parameter is optional and if it is not supplied, the other characters are left untouched.
Return type
- string
Example
CAPITALIZE( "hello" ) = "Hello"
CAPITALIZE( "WORLD" ) = "WORLD"
CAPITALIZE( "hello world " ) = "Hello world "
CAPITALIZE( " hELLo " ) = " hELLo "
UI Text Box type note The input string is not trimmed, so in this case the first character is a space.
CAPITALIZE( "hello" , TRUE ) = "Hello"
CAPITALIZE( "WORLD" , TRUE ) = "World"
CAPITALIZE( "hello world " , TRUE ) = "Hello world "
CAPITALIZE( " hELLo " , TRUE ) = " hello "
UI Text Box type note The input string is not trimmed, so in this case the first character is a space.
CAPITALIZE( ? ) = ?
TRIM
TRIM
strips the leading and trailing spaces from a string
Syntax
Code Block |
---|
TRIM ( string ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- string
Example
TRIM( "Hello" ) = "Hello"
TRIM( "Hello World" ) = "Hello World"
TRIM( " Hello World " ) = "Hello World"
TRIM( ? ) = ?
INDEXOF
INDEXOF
returns the index of the first occurrence of a specified substring in a string
Syntax
Code Block |
---|
INDEXOF ( string , substring ) INDEXOF ( string , substring , startIndex ) |
- 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.
- startIndex - A positive integer value indicating at which character the search for the substring should start (inclusive). This can be either an attribute of base type integer, an expression that results in an integer or a constant integer value. The first character starts at index 0.
Return type
- integer - the index of the first occurrence of the specified substring or -1 if it is not found
Example
INDEXOF( "Hello world" , "o" ) = 4
INDEXOF( "Hello world" , "o" , 5 ) = 7
INDEXOF( "Hello world" , "a" ) = -1
INDEXOF( "Hello world" , "o" , 8 ) = -1
LASTINDEXOF
LASTINDEXOF
returns the index of the last occurrence of a specified substring in a string
Syntax
Code Block |
---|
LASTINDEXOF ( string , substring ) LASTINDEXOF ( string , substring , startIndex ) |
- 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.
- startIndex - A positive integer value indicating at which character the search for the substring should start (inclusive), searching backwards. This can be either an attribute of base type integer, an expression that results in an integer or a constant integer value.
Return type
- integer - the index of the last occurrence of the specified substring or -1 if it is not found
Example
LASTINDEXOF( "Hello world" , "o" ) = 7
LASTINDEXOF( "Hello world" , "o" , 6 ) = 4
LASTINDEXOF( "Hello world" , "a" ) = -1
LASTINDEXOF( "Hello world" , "o" , 3 ) = -1
SUBSTRING
SUBSTRING
returns the substring of a given string starting from the index provided and ending at the end index if provided, or the end of the string
Syntax
Code Block |
---|
SUBSTRING ( string , startIndex ) SUBSTRING ( string , startIndex , endIndex ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
- startIndex - A positive integer value indicating at which character the substring should start (inclusive). This can be either an attribute of base type integer, an expression that results in an integer or a constant integer value. The first character starts at index 0.
- endIndex - A positive integer value indicating at which character the substring should end (exclusive). This can be either an attribute of base type integer, an expression that results in an integer or a constant integer value. The
endIndex
cannot exceed the length of the string and should be larger than the startIndex.
Return type
- string
Example
SUBSTRING( "Hello world" , 1 ) = "ello world"
SUBSTRING( "Hello world" , 0 , 1 ) = "H"
SUBSTRING( "Hello world" , 1 , 5 ) = "ello"
SUBSTRING( "Hello world" , 0 ) = "Hello world"
SUBSTRING( "Hello world" , 0 , LENGTH( "Hello world" ) ) = "Hello world"
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
Code Block |
---|
SUBSTRING-BEFORE ( string , substring ) |
- 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
SUBSTRING-BEFORE( "hello:world" , ":" ) = "hello"
SUBSTRING-BEFORE( "hello:world:all
" , ":" ) = "hello"
SUBSTRING-BEFORE( "hello:world" , "h" ) = ""
SUBSTRING-BEFORE( "hello:world" , "a" ) = ""
SUBSTRING-BEFORE( "" , "hello" ) = ""
SUBSTRING-BEFORE( "hello" , "" ) = ""
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
Code Block |
---|
SUBSTRING-AFTER ( string , substring ) |
- 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
SUBSTRING-AFTER( "hello:world" , ":" ) = "world"
SUBSTRING-AFTER( "hello:world:all
" , ":" ) = "world:all"
SUBSTRING-AFTER( "hello:world" , "a" ) = ""
SUBSTRING-AFTER( "" , "hello" ) = ""
SUBSTRING-AFTER( "hello" , "" ) = ""
SPLIT
SPLIT
returns a multivalue attribute containing every substring that is delimited by the given pattern
Syntax
Code Block |
---|
SPLIT ( string , pattern ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
- 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.
Return type
- string (multivalue)
Example
SPLIT( "Hello world" , "o" ) = [ "Hell" , " w" , "rld" ]
SPLIT( "Hello world" , "a" ) = [ "Hello world" ]
SPLIT( "Hello" , "o" ) = [ "Hell" , "" ]
SPLIT( "ooo" , "o" ) = [ "" , "" , "" , "" ]
- Usage: remove dots from a string in combination with the JOIN function
JOIN( SPLIT( "H.E.L.L.O" ) , ".") = "HELLO"
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 , string , replacement ) |
- 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
REPLACE( ":", "hello:world:example" , " " ) = "hello world example"
REPLACE( "o" , "hello world" , "a" ) = "hella warld"
REPLACE( "O" , "hello world" , "a" ) = "hello world"
REPLACE( "\s" , "hello world example" , "" ) = "helloworldexample"
REPLACE( "\d{2}" , "hello1 world22 example333" , "@" ) = "hello1 world@ example@3"
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 |
---|
EQUALS ( string1 , string2 ) |
- 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
EQUALS( "hello" , "hello" ) = TRUE
EQUALS( "hello" , "Hello" ) = FALSE
UI Text Box type note Note that "hello" = "Hello" will return TRUE because it is case insensitive
EQUALS( "hello " , "hello" ) = FALSE