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.

Relay.app step creation dialog showing Transform data option highlighted in the Utilities section
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

Use the "Format as text" option in the transform menu to format a date or date-time into a specifically formatted string

Transform data step showing date formatting configuration with input date and output text format
Format a date

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

Transform data step configured to extract domain from email address using Extract domain transformation
Extract the @domain from an email address

3. Add/subtract/multiply/divide numbers

Transform data step showing arithmetic operations configuration with number input and mathematical transformation options
Perform arithmetic operations on numbers

4. Format a number as a currency

Transform data step configured to format a number as currency using the As currency transformation
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.

Transform data step showing Split into list transformation converting comma-separated text into a list format
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

Last updated

Was this helpful?