Get help for ARIS Process Mining functions and services

trim(<value>): Returns a value with all leading and trailing whitespaces removed from <value>.

Example

trim(" 1 2 3 ") returns "1 2 3"

concat(<value_1>, <value_2>, ...): Returns a value with all provided values concatenated.

Example

concat("This", " is", " a", " test") returns "This is a test"

substr(<value>, <startposition>, <length>): Returns a value that is a substring of the <value>. The substring begins at <startposition> and contains up <length> characters including <startposition>. If the string ends before, fewer than length parameters are returned. The first character of the "value" has position "1". If <startpositon> is set to "0", this is internally automatic be replaced by "1".

Example

substr("This is a test", 1, 4) returns "This"

substr("This is a test", 0, 4) returns "This"

substr("This is a test", 11, 4) returns "test"

substr("This is a test", 11, 7) returns "test"

substr("This is a test", 20, 4) returns ""

You can also combine several operators.

Example

trim(concat(" This", " ", concat("is", " a "), substr("1 2 3 test ",7))) returns "This is a test"