Expression Language Emulator

Expression language statement

Result

Result

History

Quick Reference

Strings

concat(a,b) - combine strings
endsWith(a,b) - does 'a' end with 'b'?
indexOf(a,b) - integer position of 'b' in 'a'
lastIndexOf(a,b) - last position of 'b' in 'a'
replace(a,b,c) - replace 'b' in 'a' with 'c'
split(a,b) - break a into an array splitting on 'b'
startsWith(a,b) - true if 'a' begins with 'b'
substring(a,b) - return portion of 'a' based on position 'b'
toLower(a) - convert 'a' to lowercase
toUpper(a) - convert 'a' to uppercase
trim(a) - remove whitespace start and end of 'a'

Collections

contains(a,b) - does 'a' contain 'b'?
empty(a) - does 'a' have no elements?
first(a) - return the 1st item of 'a'
intersection(a,...) - return items in all passed collections
join(a,b) - a string with members of 'a' separated by 'b'
last(a) - return the last element of 'a'
length(a) - number of items in 'a'
skip(a,b) - remove 'n' items from front of 'a'
take(a,b) - opposite of skip
union(a,...) - a collection with all items from passed collections

Logical

and(a,b) - true if both 'a' and 'b' are true
equals(a,b) - true if 'a' = 'b'
greater(a,b) - true if 'a' > 'b'
greaterOrEquals(a,b) - true if 'a' > 'b' or 'a' = 'b'
if(a,b,c) - if a is true then return b else return c
less(a,b) - true if a < b
lessOrEquals(a,b) - true if a < b or a = b
not(a) - false if a is true else true
or(a,b) - true if a or b is true

Conversion

array(a) - convert 'a' to an array
base64(a) - base64 encode 'a'
base64ToBinary(a) - binary version of 'a'
base64ToString(a) - convert 'a' from base64 to a string
binary(a) - return 'a' in binary
bool(a) - return 'a' as a boolean
coalesce(a,...) - return first non null argument
createArray(a,...) - create array from arguments
dataUri(a) - convert 'a' to URI format
dataUriToBinary(a) - convert URI 'a' to binary format
dataUriToString(a) - convert URI 'a' to a string
decodeBase64(a) - decode 'a' that has been base 64 encoded
dataUri(a) - convert 'a' to URI format
decodeUriComponent(a) - convert 'a' from URI format
encodeUriComponent(a) - convert 'a' to URI format
float(a) - convert 'a' to a floating point number
int(a) - convert 'a' to an integer
json(a) - (α) convert 'a' to JSON representation
string(a) - convert 'a' to a string
uriComponent(a) - URI encode 'a'
uriComponentToBinary(a) - convert URI 'a' to binary
uriComponentToString(a) - convert URI 'a' to a string
xml(a) - (α) convert 'a' to an XML representation
xpath(x,xp) - not implemented: return nodes of XML 'x' that match xPath 'xp'

Math

add(a,b) - add 'a' to 'b'
div(a,b) - divide 'a' by 'b'
max(a,...)) - return the largest argument
min(a,...) - return the smallest argument
mod(a,b) - remainder from dividing 'a' by 'b'
mul(a,b) - multiply 'a' by 'b'
rand(a,b) - return a random number between 'a' and 'b'
range(a,b) - integer array of 'b' elements starting at 'a'
sub(a,b) - subtract 'b' from 'a'

Dates

addDays(a,b,c) - add 'b' days to timestamp 'a' format using 'c'
addHours(a,b,c) - add 'b' hours to timestamp 'a' format using 'c'
addMinutes(a,b,c) - add 'b' minutes to timestamp 'a' format using 'c'
addSeconds(a,b,c) - add 'b' seconds to timestamp 'a' format using 'c'
addToTime(a,b,c,d) - add 'b' of interval 'c' to timestamp 'a' format using 'd'
convertFromUtc(a,b,c) - convert timestamp 'a' to destination timezone 'b' format using 'c'
convertTimeZone(a,b,c,d) - convert timestamp 'a' from timezone 'b' to timezone 'c' format using 'd'
convertToUtc(a,b,c) - convert timestamp 'a' from timezone 'b' to UTC, format using 'c'
dayOfMonth(a) - return the day of month for timestamp 'a'
dayOfWeek(a) - return the day of month for timestamp 'a'
dayOfYear(a) - return the day of month for timestamp 'a'
formatDateTime(a,b) - return timestamp 'a' formatted using format string 'b'
getFutureTime(a,b,c) - return a 'a' number of 'b' units from current time, format using 'c'
getPastTime(a,b,c) - return a 'a' number of 'b' units back from current time, format using 'c'
startOfDay(a) - return timestamp 'a' rounded down to start of day
startOfHour(a) - return timestamp 'a' rounded down to start of hour
startOfMonth(a) - return timestamp 'a' rounded down to start of month
subtractFromTime(a,b,c,d) - substract 'b' of interval 'c' to timestamp 'a' format using 'd'
ticks(a) - return number of ticks since timestamp 'a'
utcNow() - return current time