Make.com SubString String Function - 5 Example Use Cases

✅ Timestamps
0:00 Introduction
0:13 Extract First 5 Characters
0:55 Extract Last 5 Characters
3:19 Extract File Name
4:50 Extract File Extension
6:02 Extract Value from HTML

✅ Video Summary:

All right, so the first thing we're gonna do is we're gonna look at kind of a typical substring example is we're gonna extract the first five characters of the string. So the way the substring function works is you have four elements here.

The next use case we're gonna look at is to extract the last five characters of a string. In this case, we're gonna use our file names and get the last five characters.

We put our file name here and then what we're gonna do for that first number is we're gonna calculate the length of the file name and then back up five steps.

Then we're gonna use a subtract math function and we're gonna put the number five, or whatever number you wanna back away from the last character.

The next thing we're gonna do is we're gonna cut this file name in half and get the file name before the dot and extension.

So we wanna know what's the index, the number of the dot character in our string. So that's gonna return a number and that's gonna be our ending point.

So, what we're gonna do is we're gonna use our substring and we're gonna start at the dot and go to the end of our full file name which will give us the extension only without the dot.

✅ You can also follow me on:

==============================

✅ My Playlists

✅ Other videos might be interested in Watching:

👉 Make Tutorial: How to Use the Integromat SubString Function with 5 Example Use Cases (2022)

👉 How to Get Help With Make (formerly Integromat) - How to Get Make Support and Make Partner Support

👉 Monday Integrations: Search Integration Modules for Make (Integromat) - Support Documentation

✅ About Weblytica :

I’m a Workflow and Process Automation Architect with a development background who helps small businesses streamline workflows and digital processes. I work with businesses of all sizes to integrate and automate their separate cloud-based services to help businesses run more efficiently.

I automate manual business workflows, integrating data from multiple cloud service providers, build dashboards and build code-free databases to increase business capacity and efficiency.

I am a Registered Make Partner. Make (formerly Integromat) is the most powerful and cost effective automation platform available.

For Business Inquiries please use the contact information below:

=========================
#integromatsubstringfunction #integromattutorial #howtouseintegromat #howtosplittextinintegromat #integromatmapfunction #bestintegromattutorial #integromathowto #integromattutorialforbeginners2022 #integromatdatastore

✅ Related Phrases:

Integromat Substring Function, Integromat Tutorial, How To Use Integromat, How To Split Text In Integromat, Integromat Map Function, Best Integromat Tutorial, Integromat How To, Integromat Tutorial For Beginners 2021, Integromat Data Store, How To Use Math In Integromat, Integromat Math Functions, Integromat Training, How To Calculate In Integromat, How Integromat Works, Integromat Techflow

Disclaimer: We do not accept any liability for any loss or damage which is incurred from you acting or not acting as a result of reading any of our publications. You acknowledge that you use the information we provide at your own risk. Do your own research.

© Weblytica, LLC

[JPVolpato]

Thank you my friend! This video was quite a shortcut for me! Cheers!

[brettkinggubby]

Great video! Thanks for this. I would love to see you implement this into a scenario that pulls URLs from a google sheet or CSV and pulls site logo images, social links, emails, etc... So, one could target companies that they want to connect with and start generating a database that shows you where to find the best places to reach out... Thanks again for this amazing video!

[LisaMyers-qhmc]

Love this vid. helps me a ton as beginner

[DataTechniques]

Thanks Andy, this was exactly what I was looking for. I need to determine what kind of file a user was uploading so I could route it to a different branch of the scenario. 👍

[danielattard]

Very informative. Thanks for accelerating my learning of this powerful tool.🤟

[kodifletcher]

Super helpful! I may reach out soon for some help.

[MaikonSchiessl]

That is very helpful video. How can I do the opposite? I want to return the content inside </p> ??

[DichVuGuiHangQuocTe]

"I want to split content into two parts, requiring the split point to be in the middle without abruptly breaking any words. Please help me. I couldn't use substring and other functions, so I need to use ChatGPT to perform the split

[maolchal]

Very good! I just started using the integromat and I need to format a date that I get as YYYYMMDD and I'm testing this format
👇
eg: 20220421
{{substring(DATE; 6; 2)}}/
{{substring(DATE; 4; 2)}}/
{{substring(DATE; 0; 4)}}
to: 21/04/2022

but it loads in sheets this value
2204/22/2022

Do you have any idea?

Thank you

[christianorsos]

How can I replace numbers into text? Let's say replacing "300, 000" into "three hundred thousand"