String Functions

ascii (text; [remove diacritics])

Removes all non-ascii characters from a text string.

= Integromat
= escrz

base64 (text)

Transforms text to base64.

= aW50ZWdyb21hdA==

Hint: combine the toBinary() and toString() functions to transform base64 encoded text to plain text:

= integromat

capitalize (text)

Converts the first character in a text string to uppercase.

= Integromat

contains (text; search string)

Verifies if text contains the search string.

contains(Hello World;Hello)
= true
contains(Hello World;Bye)
= false

decodeURL (text)

Decodes special characters in URL to text.

= Automate your workflow

encodeURL (text)

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

escapeHTML (text)

Escapes all HTML tags in text.

= &lt;b&gt;Hello&lt;/b&gt;

indexOf (string; value; [start])

Returns the position of the first occurrence of a specified value in a string. This method returns '-1' if the value searched for never occurs.

= 2
= -1
= 9

length (text or buffer)

Returns the length of text string (number of characters) or binary buffer (buffer size in bytes).

= 5

lower (text)

Converts all alphabetical characters in a text string to lowercase.

= hello

md5 (text)

Calculates the md5 hash of a string.

= d155951844a40fb856108d803d4de33e

replace (text;search string; replacement string)

Replaces the search string with the new string.

replace(Hello World;Hello;Hi)
= Hi World

Regular expressions (enclosed in /.../) can be used as search string with a combination of flags (like g, i, m) appended:

= All these numbers X X X X will be replaced with X

The replacement string can include the following special replacement patterns:

$& Inserts the matched substring.
$n Where n is a positive integer less than 100, inserts the nth parenthesized submatch string. Note that this is 1-indexed.

= Phone number is +420777111222

= Phone number: +420777111222
Do not use named capture groups like / is (?<number>\d+)/ in the replacement string argument as this will throw an error.

See Text parser's documentation for further information on regular expressions.

sha1 (text; [encoding]; [key])

Calculates the sha1 hash of a string. If the key argument is specified, sha1 HMAC hash is returned instead. Supported encodings: `hex` (default), `base64` or `latin1`.

= 5572e727b5822e06d7d13c69f51b3addbfa5390f

sha256 (text; [encoding]; [key])

Calculates the sha256 hash of a string. If the key argument is specified, sha256 HMAC hash is returned instead. Supported encodings: `hex` (default), `base64` or `latin1`.

= 17722b391d8f2004020cc7445685451bc42bf8f6621d7866ba96e8ffa42b68aa

sha512 (text; [output encoding]; [key]; [key encoding])

Calculates the sha512 hash of a string. If the key argument is specified, sha512 HMAC hash is returned instead. Supported encodings: `hex` (default), `base64` or `latin1`. Supported key encodings: `text` (default), `hex`, `base64` or `binary`. When using `binary` key encoding, a key must be a buffer, not a string.

= dbb0c7d5aa108aca5d2476d00885a98aef9f9ed9ad1c4635abaf9c104793844b7dc52e0dfab43c893c55ff4a9db5d69b8be479716ee53149337456694f7aed7c

split (text; separator)

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

split(John, George, Paul;,)

startcase (text)

Capitalizes the first letter of every word and lower cases all other letters.

startcase(hello WORLD)
= Hello World

stripHTML (text)

Removes all HTML tags from text.

= Hello

substring (text; start;end)

Returns a portion of a text string between the "start" position and "the end" position.

= Hel
= el

toBinary (value)

Converts any value to binary data. You can also specify encoding as a second argument to apply binary conversions from hex or base64 to binary data.

= 496e746567726f6d6174
= 496e746567726f6d6174

toString (value)

Converts any value to a string.

trim (text)

Removes space characters at the start or end of the text.

upper (text)

Converts all alphabetical characters in a text string to uppercase.


Popular use cases from our blog


How to Easily Import Leads from Facebook to Mailchimp and Airtable


How to Boost ActiveCampaign Automations With Integromat


Instagram for Business Automation: 3 Powerful Templates to Get Started


Automated Reporting: Get Rolling With 4 Easy, Practical Solutions


Can You Tweet From Notion? Yes, and Here’s How to Do It [Tutorial]


Slack Automation: 20 Free Templates to Get You Inspired

Didn’t find what you were looking for?


Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.