How to Use the Make SubString Function with 5 Example Use Cases

What is Make?

Make is a visual platform for anyone to design, build, and automate anything—from tasks and workflows to apps and systems—without coding. SMBs, startups, scaleups, teams, and enterprises around the world use Make to create powerful solutions that scale their business faster than ever.

Create a Make Account »

How to Use the Make SubString Function with 5 Example Use Cases

Learn How to Use the Integromat SubString Function with 5 Example Use Cases

Extract First 5 Characters of String

1. my_audio.mp3
2. my_audio_2.mp3
3. my_pdf_filename.pdf
4. my_word_doc_filename.docx

substring(File Name;0;5)

Extract Last 5 Characters of String

1. my_audio.mp3
2. my_audio_2.mp3
3. my_pdf_filename.pdf
4. my_word_doc_filename.docx

substring(File Name;length(File Name)–5;length(File Name))

Extract File Name (Before the Period)

1. my_audio.mp3
2. my_audio_2.mp3
3. my_pdf_filename.pdf
4. my_word_doc_filename.docx

substring(File Name;0;indexOfFile Name;.))

Extract File Extension (After the Period)

1. 1. my_audio.mp3
   2. my_audio_2.mp3

1. my_pdf_filename.pdf
2. my_word_doc_filename.docx

substring(File Name;indexOfFile Name;.)+1;length(File Name))

Extract Value from HTML (Website or Email)

Name: Andy O’Neil

Account #123456789

Thank you for your business!

Sincerely,
Weblytica, LLC

HTML Code

<p>Name: Andy O'Neil</p>
<p>Account #123456789</p>
<p>Thank you for your business!</p>
<p>Sincerely,<br>
Weblytica, LLC</p>

Two-Step Process (Step 1)

<p>Name: Andy
O'Neil</p>
<p>Account #123456789</p>
<p>Thank you for your business!</p>
<p>Sincerely,<br>
Weblytica, LLC</p>

Cut the HTML at “Account #”

substring(HTML;indexOfHTML;Account #)+9;length(HTML))

The Result:

123456789</p>
<p>Thank you for your business!</p>
<p>Sincerely,<br> Weblytica, LLC</p>

Two-Step Process (Step 2)

Cut the HTML at the </p> After the Number

substring(HTML;0;indexOfHTML;</p>))

The Result:

123456789


Add Trim Function to Remove Whitespace:

trim(substring(HTML;0;indexOfHTML;</p>)))

About Make

Make (formerly Integromat) is the leading visual platform for anyone to design, build, and automate anything—from tasks and workflows to apps and systems—without the need for coding skills. Founded in 2016 and acquired by Celonis in 2020, Make enables individuals, teams, and enterprises across all verticals to create powerful custom solutions that scale their businesses faster than ever. Make is headquartered in Prague, Czech Republic, and powers over 500,000+ businesses around the globe. Learn more about Make.com.