Expressions: Definitions and Usage Examples

Expressions convert input into certain formats or perform operations with the input.

Text Expressions

contains

Returns true if the value contains the input value, otherwise false.

concat

Concatenates a string to the end of another string.

(We have to enclose the statements in single quotation marks.)

lower

Converts a string to lowercase.

upper

Converts a string to uppercase.

replace(input, target, replacement)

Replaces all occurrences of a specified target substring within the input string with a given replacement substring.

substring

Returns the substring that is between the start and the end index. (end character will not be included)

For this case, start index: 0, end index: 4

capitalize

Capitalizes the first character of the input and converts remaining characters to lowercase.

length

Calculates the length of the string.

indexOf

Returns the index of the first occurrence of a specified value in a string. (Index starts from “0”.)

lastIndexOf

Returns the index of the last occurrence of a specified value in a string. (Index starts from “0”.)

removeNonAscii

Removes all non-ASCII characters from a text string.

split

Splits a string into an array of strings by separating the string into substrings.

findMatchingSubstringWithRegex(input, regex, returnMode)

Finds the first substring in the input string that matches the given regular expression. Returns a string containing either the first matched substring (if returnMode is "0"), or an array containing all matched substrings (if returnMode is "1").

Regex pattern:

\b(?:https?|ftp):\/\/[-A-Za-z0-9+&@#\/%?=~_|!:,.;]*[-A-Za-z0-9+&@#\/%=~_|]\b

Explanation: Matches URLs, such as https://www.example.com

Regex pattern:

\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b

Explanation: Matches email addresses, such as: joe@email.com

Regex pattern:

\b\d{2}\/\d{2}\/\d{4}\b

Explanation: Matches dates in MM/DD/YYYY format, such as 10/25/2024

Regex pattern:

\b\d{3}-\d{2}-\d{4}\b

Explanation: Matches number format xxx-xx-xxxx 123-45-6789

lookup(data, key)

Looks up a value associated with a given key in an array of pairs. Returns the value associated with the given key, or an empty string if the key is not found.

Example Key-Value Table Representation:

With transformation connector:

{"assets":[["Yes","Y"],["No","N"],["Product","Prod"],["Prod","Production"]]}

{"assets":[["countryOfOrigin","United States"],["supplierItemCode","115596"],["caseGtinUpc","00815154026376"],["retailGtinUpc","00815154026369"],["unitGtinUpc","00815154026369"],["retailUnitLength","2.28"]]}

{"assets":[["Value1","Key"],["Value2","Key"],["Key","TrueValue"],["Value3","Key"]]}

{"assets":[["Key1","Value1"],["Key2","Value2"],["Key3","Value3"],["Key1","Value4"]]}

escapeHTML

Escapes all HTML tags in text.

removeHTML

Removes all HTML tags from text.

convertXMLToJson

Converts the given XML string to JSON.

trim

Trims leading and trailing whitespace from the input string. Removes whitespace from the beginning and end of the provided string. Any internal whitespace within the string is not affected.

Encode/Decode Expressions

transformToBase64

Transforms string to base64.

decodeBase64

Decodes base64 to string.

decodeURL

Decodes special characters in URL.

encodeURL

Encodes special characters in a text to a valid URL address.

transformToHex

Converts string to hex data.

calculateMD5

Calculates the md5 hash of a string.

calculateSHA1

Calculates the sha1 hash of a string.

calculateSHA256

Calculates the sha256 hash of a string.

calculateSHA512

Calculates the sha512 hash of a string.

Array Expressions

Input Data:

{"ar":[1,2,1,1,3,4,6]}

addToArray

Adds the value in the input parameter to the array and returns the resulting array.

arrayContains

Checks if an array contains the value.

removeDuplicate

Removes duplicates from an array.

findFirstInArray

Returns the first element of the array.

findLastInArray

Returns the last element of the array.

removeItemWithIndex

Removes the item with given index from the given array. (index starts from 0)

clearArray

Clears an array and returns the empty array.

reverseArray

Reverses the elements of an array.

shuffleArray

Shuffles (randomly reorders) elements of an array.

The order is random, so the result changes each time it runs.

sliceArray

Slices the elements of an array based on the start and end index, and returns a new array containing only selected items between start and end index.

• Start index will be included.

• End index will be excluded.

sortArray

Sorts the elements of an array based on the order parameter.

Transformation:

{"toSort":[1,5,8,Z,a,A,b,B,*,?,-]}

• Order parameter should be either ‘asc’ or ‘desc’

  • asc - ascending order: 1, 2, 3, ... for type Number. A, B, C, a, b, c, ... for type Text.

  • desc  - descending order: ..., 3, 2, 1 for type Number. ..., c, b, a, C, B, A for type Text.

joinArray

Concatenates all the items of an array into a string, using a specified separator between each item.

Input Data:

{"ar":[1,2,1,1,3,4,6]}

Transformation:

{"flatten":[0, 1, [2, [3, [4, 5]]]]}

mergeArrays

Merges two arrays into one array and returns new array that contains all the items of first array and second array.

flattenArray

Creates a new array with all sub-array elements concatenated into it recursively up to the specified depth.

Transformation:

{"flatten":[0, 1, [2, [3, [4, 5]]]]}

transposeArray

Transposes the given array and returns resulting array.

• Example for transpose:
  

  

Input Data:

{"transpose":[[1,2,3],[4,5,6],[7,8,9]]}

toArray

Converts a collection into an array of key-value collections.

toCollection

Converts an array containing key-value pairs into a collection.

getRowSize

Returns the row size of an array.

getColumnSize

Returns the column size of an array. If sizes of the columns different in multidimensional arrays, it returns max column size as in ar2D.

Omit

Removes the input key from the input array and returns the remaining elements.

Input Data:

{"ar":[11,12,13,13,13,14]}

Pick

Returns all values that match the input key in the input array.

Input Data:

{"ar":[11,12,13,13,13,14,key]}

Logic Expressions

isEmpty

Checks whether the given input is empty or not. If empty, it returns true, otherwise false. Input can be a string, an array or an json object.

If

Returns the value in the second input (the true case) if the condition in the first input is true. If the condition is false, returns the value in the third input (the false case).

• If inside if:

• We can also use another expression within the if expression as below:

General Expressions

getFromJsonPath

Returns the value found at the given path in a JSON. Enter the JSON in the first input and the path of the variable you want to get in the second input.

{"test":{ "firstName": "John", "lastName": "doe", "age": 26, "address": { "streetAddress": "naist street", "city": "Nara", "postalCode": "630-0192" }, "phoneNumbers": [ { "type": "iPhone", "number": "0123-4567-8888" }, { "type": "home", "number": "0123-4567-8910" } ] }}

In this example, the JSON above is entered in the Transformation field of step 1.

Math Expressions

ceil(number)

Returns the smallest integer greater than or equal to a specified number.

floor(number)

Returns the largest integer less than or equal to a specified number.

formatNumber(number, decimalPoints, decimalSeparator, thousandsSeparator)

Formats a number according to the provided parameters and returns the formatted number.

parseNumber(number, decimal separator)

Parses a string with a number and returns the parsed number.

roundNumber(number)

Rounds a numeric value to the nearest integer.

convertScientificToDecimal(scientific notation)

Converts a number from scientific notation of the form "nx10^E" to decimal number.

convertDecimalToScientific(decimal number)

Converts a decimal number to scientific notation of the form "nx10^E" where n is the significand and E is the exponent.

convertDecimalToENotation(decimal number)

Converts a decimal number into scientific E notation. The scientific notation will be formatted to include all significant digits with an 'E' indicating the exponent.

convertENotationToDecimal(E notation)

Converts a number from E notation to a decimal number. Takes the input number in E notation with an 'E' or 'e' indicating the exponent.

sum(array of numbers)

Calculates the sum of numeric values in an array. Handles both integers and doubles, and ignores non-numeric values in the array. If the array contains no numeric values, the method returns an empty string.

Date Expressions

currentDateTime(format)

Returns the current date with the specified format.

addDays (date, number)

Adds or subtracts the specified number of days from the given date-time. Returns a new date as a result of adding a given number of days to a date. To subtract days, enter a negative number.

addHours (date, number)

Adds or subtracts the specified number of hours from the given date-time. Returns a new date as a result of adding a given number of hours to a date. To subtract hours, enter a negative number.

addMinutes (date, number)

Adds or subtracts the specified number of minutes from the given date-time. Returns a new date as a result of adding a given number of minutes to a date. To subtract minutes, enter a negative number.

addMonths (date, number)

Adds or subtracts the specified number of months from the given date-time. Returns a new date as a result of adding a given number of months to a date. To subtract months, enter a negative number.

addSeconds (date, number)

Adds or subtracts the specified number of seconds from the given date-time. Returns a new date as a result of adding a given number of seconds to a date. To subtract seconds, enter a negative number.

addYears (date, number)

Adds or subtracts the specified number of years from the given date-time. Returns a new date as a result of adding a given number of years to a date. To subtract years, enter a negative number.

setSecond (date, number)

Returns a new date with the seconds specified in parameters. Accepts numbers from 0 to 59.

setMinute (date, number)

Returns a new date with the minutes specified in parameters. Accepts numbers from 0 to 59.

setHour (date, number)

Returns a new date with the hour specified in parameters. Accepts numbers from 0 to 23.

setDayOfWeek (date, name of the day in English)

Returns a new date with the day specified in parameters.

setMonth (date, name of the month in English)

Returns a new date with the month specified in parameters.

setYear (date, number)

Returns a new date with the year specified in parameters.

changeDayOfMonth(date, number)

Returns a new date with the day of the month specified in parameters. Accepts numbers from 1 to 31. If a number is given outside of the range, it will return the day from the previous or subsequent month(s), accordingly.

before(date1, date2, format)

Checks if date1 is before date2.

after(date1, date2, format)

Checks if date1 is after date2.

convertDate(date1, format1, format2)

Converts a date string from one format to another.

convertDateToEpoch(date, dateFormat, epochFormat)

Converts a date string to epoch time using the specified format. The format of the epoch should be "ms" for milliseconds, "s" for seconds, "us" for microseconds, "ns" for nanoseconds. If any parameters are invalid, empty, or null, the expression will return an empty string.

convertEpochToDate(epoch, dateFormat, epochFormat)

Converts the given epoch time to a formatted date string based on the provided format. The format of the epoch should be "ms" for milliseconds, "s" for seconds, "us" for microseconds, "ns" for nanoseconds. If any parameters are invalid, empty, or null, the expression will return an empty string.

formatDateWithTimezone(date, input format, output format, timezone offset)

Converts a date string from one format to another, adjusting for the specified timezone offset. This expression can handle both date strings that include timezone information (ZonedDateTime) and those without timezone information (LocalDateTime). It applies the given timezone offset to the date, then returns the date in the desired output format with the adjusted timezone.

date: 2024-09-10T14:19:58.999Z[UTC]

input format: yyyy-MM-dd'T'HH:mm:ss.SSSX'['z']'

output format: dd-MM-yyyy'T'HH:mm:ss

timezone offset: +3

date: Last Successful Completion Time (2024-11-22T12:08:37.466Z[UTC])

input format: yyyy-MM-dd'T'HH:mm:ss.SSSX'['z']'

output format: dd-MM-yyyy'T'HH:mm:ss

timezone offset: +3

Example Expressions

Getting File Name Without The Extension

In this example, we are removing the file extension, e.g., asset123.jpg will be transformed into asset123: