Page History
Learn more about text functions CONCATENATE, JOIN, MATCH, FIND, FIRST, LAST, LENGTH, UPPERCASE, LOWERCASE, CAPITALIZE, TRIM, INDEXOF, LASTINDEXOF, SUBSTRING, SUBSTRING BEFORE, SUBSTRING AFTER, SPLIT, REPLACE, EQUALS.
Overview
Function | Description |
---|
...
CONCATENATE | Use the '+ ' (plus) operator to concatenate strings or a combination of strings and other type values to produce a single |
...
Syntax
Code Block |
---|
string1 + string2 + ... + value1 + ... |
...
...
...
string value. |
...
Return type
- string
Examples
12 + " kilometers" = "12 kilometers"
"This statement is " + TRUE + "." = "This statement is true."
"I was born on " + Me.birthDateAndTime + "." (Me.birthDateAndTime = 01-12-1970 23:00:45) = "I was born on Tue Dec 01 23:00:45 CET 1970."
UI Text Box | ||
---|---|---|
| ||
There exists a |
Joins |
JOIN
...
a series of values into one string, separated with a character of your choice |
...
Syntax
Code Block |
---|
JOIN ( argument1 , argument2 , ... , separator ) |
- argument1, argument2 - Attributes or expressions that contain the values that will be joint to a single string. JOIN works for all base types, even multivalued.
- separator - A string value that will be used as separator symbol.
Return type
- string
UI Text Box | ||
---|---|---|
| ||
an UNKNOWN value will be represented as an empty entry in the result string. |
...
type | note |
---|
...
. |
...
Suppose you have a model containing the following attributes.
...
JOIN ( Person.name , Person.date_of_birth , ";" ) = "John;Sun Jan 01 00:00:00 CET 1995"
JOIN ( Person.name , Person.name , "@" ) = "John@John"
JOIN ( Person.name , Person.family_name , YEARS BETWEEN Person.date_of_birth AND DATE ( 2015 , 01 , 01 ) , ";" ) = "John;;20"
MATCH
...
MATCH | Compares |
...
a string pattern to another string and returns TRUE if the string exactly matches the pattern, and otherwise FALSE. The MATCH function is case-sensitive |
...
Syntax
Code Block |
---|
MATCH ( pattern , string ) |
...
...
. |
...
- boolean
Examples
If the attribute File.name
is of base type string and its value is "Thisfile_1.doc" then
MATCH ( "Thisfile_1.doc" , File.name ) = TRUE
MATCH ( File.name , "Thisfile_1.doc" ) = TRUE
MATCH ( " Thisfile_1.doc" , File.name ) = FALSE
MATCH ( "thisfile_1.doc" , File.name ) = FALSE
MATCH ( "[A-Z]hisfile_1.doc" , File.name ) = TRUE
MATCH ( "[a-z]hisfile_1.doc" , File.name ) = FALSE
MATCH ( "Thisfile_[0-9].doc" , File.name ) = TRUE
MATCH ( ".............." , File.name ) = TRUE
MATCH ( ".*" , File.name ) = TRUE
MATCH ( "**" , "**" ) results in an error message, because "**" is not a valid regular expression
FIND
...
FIND | Looks for a string pattern within another string and returns the first matching characters. The function is case-sensitive |
...
Syntax
Code Block |
---|
FIND ( pattern , string )
FIND ( pattern , string , startIndex ) |
- 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.
- startIndex - A positive integer value indicating at which character of the string the search 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
- string
Examples
If File.name
is an attribute of base type string with value "Thisfile_1.doc", then:
...
FIND ( "_[1-5]" , File.name ) = "_1"
...
. |
...
FIND ( "el" , "Hello" ) = "el"
...
FIND ( "el" , "Hello" , 2 ) = UNKNOWN
...
FIND ( "eo" , "Hello" ) = UNKNOWN
...
...
FIND ( "\s[a-zA-Z]+" , "Hello world example" , 6 ) = "example"
...
Returns the first character(s) of a string, based on the number of characters you specify |
...
Syntax
Code Block |
---|
FIRST integer CHARACTERS OF string
FIRST 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. FIRST CHARACTER OF can be used to retrieve only the first 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_FRONT( string, integer ) function. Example: STR_FRONT("Blueriq", 3) = "Blu" |
Examples
If File.name
is an attribute of base type string with value "Thisfile_1.doc" and the integer attribute File.prefix
has value 8 then:
...
FIRST File.prefix CHARACTERS OF File.name = "Thisfile"
...
. |
...
...
Returns the last character(s) of a string, based on the number of characters you specify. |
...
Syntax
...
- 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 ( ? ) = ?
UPPERCASE
...
. | |
UPPERCASE | Returns a string with all characters in uppercase |
...
Syntax
Code Block |
---|
UPPERCASE string
UPPERCASE ( string ) |
...
. |
...
Return type
- string
Example
...
UPPERCASE ( "hello" ) = "HELLO"
...
...
...
UPPERCASE ( "hello world " ) = "HELLO WORLD "
...
UPPERCASE " hELLo " = " HELLO "
...
LOWERCASE | Returns |
LOWERCASE
...
a string with all characters in lowercase |
...
. | |
CAPITALIZE | Returns |
Syntax
Code Block |
---|
LOWERCASE string
LOWERCASE ( string ) |
- string - An attribute of base type string, an expression that results in a string or a constant string value.
Return type
- string
Example
LOWERCASE ( "hello" ) = "hello"
LOWERCASE "WORLD" = "world"
LOWERCASE ( "Hello World " ) = "hello world "
LOWERCASE " hELLo " = " hello "
LOWERCASE ( ? ) = ?
CAPITALIZE
...
a string with the first character uppercased |
...
Syntax
Code Block |
---|
CAPITALIZE string
CAPITALIZE ( string )
CAPITALIZE ( string, lowerTheRest ) |
...
...
. |
...
Return type
- string
Example
...
CAPITALIZE ( "hello" ) = "Hello"
...
CAPITALIZE "WORLD" = "WORLD"
...
CAPITALIZE ( "hello world " ) = "Hello world "
...
...
...
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 | ||
---|---|---|
| ||
The input string is not trimmed, so in this case the first character is a space. |
...
TRIM | Strips |
TRIM
...
the leading and trailing spaces from |
...
Syntax
Code Block |
---|
TRIM string
TRIM ( string ) |
...
a string |
...
. |
...
Return type
- string
Example
...
TRIM "Hello" = "Hello"
...
...
...
Returns the index of the first occurrence of a specified substring in a string |
...
Syntax
Code Block |
---|
INDEXOF ( string , substring )
INDEXOF ( string , substring , startIndex ) |
...
...
. |
...
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
...
...
...
Returns the index of the last occurrence of a specified |
...
Syntax
...
substring |
...
in |
...
a |
...
string |
...
. |
...
...
SUBSTRING | Returns |
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
...
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 |
...
. | |
SUBSTRING BEFORE | Returns |
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
...
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 substring IN string
SUBSTRING_BEFORE ( string , substring ) |
...
. |
...
...
Return type
- string
Example
...
...
AFTER | Returns |
SUBSTRING_AFTER
...
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 substring IN string
SUBSTRING_AFTER ( string , substring ) |
...
. |
...
...
Return type
- string
Example
...
...
SPLIT | Returns a multivalued string |
SPLIT
...
attribute containing every substring that is delimited by the given pattern. |
Syntax
Code Block |
---|
SPLIT string ON pattern
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" ON "o" = [ "Hell" , " w" , "rld" ]
SPLIT ( "Hello world" , "a" ) = [ "Hello world" ]
SPLIT "Hello" ON "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 IN string WITH replacement
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 ":" IN "hello:world:example" WITH " " = "hello world example"
REPLACE ( "o" , "hello world" , "a" ) = "hella warld"
REPLACE ( "O" , "hello world" , "a" ) = "hello world"
REPLACE "\s" IN "hello world example" WITH "" = "helloworldexample"
REPLACE ( "\d{2}" , "hello1 world22 example333" , "@" ) = "hello1 world@ example@3"
REPLACE ( "" , "hello world" , " " ) = " h e l l o w o r l d "
EQUALS
REPLACE | Replaces every occurrence of a string pattern within another string with a provided replacement string. The function is case-sensitive. |
EQUALS | Compares two strings and returns TRUE if and only if they are equal. This function is case sensitive. |
Go here for more info on the Text Substitution Language (TSL) documentation.
Functions
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
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 ) |
- 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
...
"hello" EQUALS "hello" = TRUE
...
EQUALS ( "hello" , "Hello" ) = FALSE
UI Text Box | ||
---|---|---|
| ||
Note that "hello" = "Hello" will return TRUE because it is case insensitive |
...
"hello" EQUALS "hello " = FALSE
...