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. 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)

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

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.

Book an Make Support Session

Starting at $99

Includes 60 Minutes to

Work on Your Scenario(s)

Meet via Zoom to Build or Fix Your Scenario in Real-Time With You

Excellent Way to Learn Make

No Remote Login Required & No Passwords Shared

$99 Each Additional Hour

100% Money-Back Satisfaction Guarantee!

Select a Support Provider Below