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.
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
- my_audio.mp3
- my_audio_2.mp3
- my_pdf_filename.pdf
- my_word_doc_filename.docx
substring(File Name;0;5)
Extract Last 5 Characters of String
- my_audio.mp3
- my_audio_2.mp3
- my_pdf_filename.pdf
- my_word_doc_filename.docx
substring(File Name;length(File Name)–5;length(File Name))
Extract File Name (Before the Period)
- my_audio.mp3
- my_audio_2.mp3
- my_pdf_filename.pdf
- my_word_doc_filename.docx
substring(File Name;0;indexOfFile Name;.))
Extract File Extension (After the Period)
-
- my_audio.mp3
- my_audio_2.mp3
- my_pdf_filename.pdf
- 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.