Available transform functions

Introduction

Available transform functions are summarised in the following categories:

• Array

• Date & time

• Number

• Other

• String

Array

Transform	Description
Join	Join elements of an array as a string, based on a defined delimiter.

Date & time

Transform	Description
Custom dynamic date	Apply the date that a process flow runs, with or without adjustments.
Custom static date	Apply a static date.
Format	Convert a date to a predefined or custom format.
Round date	Round a date up/down to the start/end of the day.
Time now	Returns the current date and time in your required format.
Timezone	Convert dates to a selected timezone.

Number

Transform	Description
Cast to boolean	Convert a number value to a boolean (true/false) value based on PHP logic.
Cast to string	Change the source field data type from number to string.
Ceiling	Round up to the nearest whole number.
Custom number	Apply a static number.
Floor	Round down to the nearest whole number.
Make negative	Convert number to a negative.
Make positive	Convert number to a positive.
Math	Perform a mathematical operation for selected fields.
Round number	Change the number of decimal places.

Other

Transform	Description
Cast to boolean	Define override values for conversion to true/false.
Cast boolean to string	Change the source field data type from boolean to string.
Cache lookup	Reference a value from cached data.
Convert weight	Convert a specified weight unit to a given alternative.
Custom boolean	Apply a true or false value.
Fallback	Set a default value to be used if the given input is empty. Blank values are supported.
Map	Convert values using a cross-reference lookup.
Null to string	Convert a null value to an empty string.
Null to zero	Convert a null value to zero (0).
Null value	Convert a source value to null.
Script	Apply a field-level custom script. Note that a script will time out if it runs for more than 120 seconds.

String

Transform	Description / Notes
Cast to float	Change the source field data type from string to float.
Cast to number	Change the source field data type from string to number.
Concatenate	Join selected fields with a selected character.
Contains one of many	Specify a comma separated list of field values to be matched for inclusion.
Convert string to boolean	Convert a string value to a boolean (true/false) value based on PHP logic.
Country code	Apply country codes of a selected type (Alpha 1, Alpha 2, Numeric). Note that this transform will cause the map step to fail if an empty value is received.
Country name	Return the country name for a country code. Note that this transform will cause the map step to fail if an empty value is received.
Custom string	Apply static text or reference variables.
Does not contain one of many	Specify a comma separated list of field values to be matched for exclusion.
First word	Get the first word from a string.
Hash	Convert a string to a SHA1 Hash.
JSON encode	Encode data into JSON format. Note that although this is listed as a string type transform, any data type is supported.
Last word	Get the last word from a string.
Limit	Truncates a string to a given length.
Lowercase	Convert to lowercase.
Pad	Pad an existing string of characters to a given length, using a given character.
Prefix	Add a string to the beginning of a field.
Replace	Replace any given character(s) with another character.
Split	Split elements of a string into an array.
Substring	Return a given number of characters from a given start.
Suffix	Add a string to the end of a field.
Trim whitespace	Remove any characters around a string.
Uppercase	Convert to uppercase.
URL decode	Convert an encoded URL into a readable format.
URL encode	Convert a string to a URL encoded string.