Transform data

Relay.app has a powerful transform data step that lets you transform your data in any way you want. This is very useful in case you need to do things such as multiplying a number, converting a number to a string, or adding a couple of days to date.

You can find the 'Transform data' step in the 'Utilities' menu

Here is a short video on how to use and configure the transform data step:

Data Transformation examples

1. Format a Date the way you need it

Format a date

2. Extract the (company) domain from an email address

Extract the @domain from an email address

3. Add/subtract/multiply/divide numbers

Perform arithmetic operations on numbers

4. Format a number as a currency

Format a number as any currency

5. Convert comma-separated-values into a List

Use this powerful data transformation to split comma-separated values of text (e.g. Jane, John, Mike, Alex ) into a List that can be used with an Iterator.

Split comma-separated values into a List

Full list of Data Transformations

Updated : 2025-02-21

Input	Transformation	Output
Text	Extract date	Date
Text	Extract time	Time
Text	Parse as Unix seconds	DateTime
Text	Parse as Unix milliseconds	DateTime
Text	Parse as duration in unit	Duration
Text	Split into list	Text
Text	Split and take	Text
Text	Extract domain	Text
Text	Parse as Email	Email
Text	Parse as URL	URL
Text	Parse as number	Number
Text	Parse as date/time	DateTime
Text	Parse as date	Date
Text	Parse as phone number	Phone
Text	Parse as Markdown	Rich Text
Text	Parse as HTML	Rich Text
Text	Prepend text	Text
Text	Append text	Text
Text	Replace text	Text
Text	Replace all	Text
Text	Pad start	Text
Text	Pad end	Text
Text	Uppercase	Text
Text	Lowercase	Text
Text	Adjust case	Text
Text	Trim	Text
Text	URL encode	Text
Text	Base64 encode	Text
Text	Base64 decode	Text
Text	Hash	Text
Text	From A to B	Text
Text	Length	Number
Rich Text	Plain text	Text
Number	Add	Number
Number	Subtract	Number
Number	Multiply by	Number
Number	Divide by	Number
Number	Modulo by	Number
Number	Raise to power	Number
Number	Logarithm	Number
Number	As text	Text
Number	As currency	Text
Number	As words	Text
Number	As ordinal	Text
Number	Absolute	Number
Number	Ceiling	Number
Number	Floor	Number
Number	Round	Number
DateTime	Add	DateTime
DateTime	Subtract	DateTime
DateTime	Add duration	DateTime
DateTime	Subtract duration	DateTime
DateTime	Time until	Duration
DateTime	Time since	Duration
DateTime	Difference to now	Duration
DateTime	Set time	DateTime
DateTime	Start of	DateTime
DateTime	Shift to time zone	DateTime
DateTime	Next working day	DateTime
DateTime	As ISO 8601 string	Text
DateTime	As text	Text
DateTime	As Unix seconds	Text
Duration	Add	Duration
Duration	Subtract	Duration
Duration	Add to date	DateTime
Duration	Subtract from date	DateTime
Duration	As ISO 8601 string	Text
Duration	As text	Text
Duration	As number	Text
List	Join list items	Text
JSON	Get value at pointer	Text