Integromat Text Functions [2022 Tutorial]

[@rtkkjson]

You are a time saver!

[@eboyd53]

You gave me an idea for using this to create a form letter with replacement values. 💯

[@maxvcollenburg]

Awesome! Happy to hear it gave you some inspiration 😄

[@RosinaP]

Hey Max, thank you so much for your tutorials. For future tutorials: could you please explain what you are trying to achieve and show a demo at the beginning of the video and then go to the steps. Thanks

[@maxvcollenburg]

Good idea! Thanks for the feedback 🤗

[@luiz_carlos]

Dude, this video helped me a lot. I was trying to integrate Gmail with splitwise and was having a hard time. I managed to create the integration thanks to you.

[@maxvcollenburg]

Hey Luiz! Happy to hear it helped you so much! 😄

[@sleepymonk8239]

Thank you alot, with this video, I was able to generate a custom reference/invoice number according to customer information and date🎉🎉🎉🎉🎉

[@maxvcollenburg]

Whohooo, nice! Happy to hear this video helped 😄

[@andrewpndavies]

Great video! So helpful - thank you

[@maxvcollenburg]

Hey Andrew! Glad you like it! 😄

[@vladislavv4977]

Great video and cool vibe to learn more about integromat. Thanks a lot

[@maxvcollenburg]

Thanks! Glad you like it! 😄

[@hadaseytan1707]

Hi Max and thanks for a great video! do you have any thoghts about how to slove this need?
I have strings of different words, and need to eraseqreplace some of them.
for example, tags are: house, car, chair, table; and I want to erase "car".
the strings are different for each product.
I thoght using "Index of" and then replace the word, but the index is for letters not whole words...
Do you have any idea? THANKS!

[@DataTechniques]

Great overview 👍

[@maxvcollenburg]

Thanks! Glad you like it 😄👍

[@simonelphick8790]

Hi Max - enjoying these tutorils! As requested:
in English this " ;" is a semicolon. And "ascii" we pronounce a-ski (a as in apple)!

[@maxvcollenburg]

Haha, thanks for letting me know!
I should make a list with the name of all these glyphs 😋

[@cottagekeeper]

Hi Max, trying to learn Integromat, I'm finding it very challenging. Would you consider creating a video that shows how to parse gmail data into airtable using Integromat? I feel like a ton of people could benefit from this. Many thanks for all you do!

[@maxvcollenburg]

Hey Lisa! What kind of Gmail data would you like to format & put into an airtable?
That would help me to show a relevant example 🙃

[@christianorsos]

What if you wanted to replace numbers? For example, replace '1000000' with '1 Million' how would you do that?

[@uswebstudio7984]

Thanks Max for the video. So very basic question, if I just want to split the text in module like a normal paragraph to send in an email, should I just use split ( whatever text. newline) ? And do this for the whole email template? Or is there a faster workaround? cheers

[@thecuppiecakesqueen2832]

This is what I came to.fond out. A year later it still hasn't been answered. 🥴

[@ИванТищенко]

Thank you Max) very usefull!
One question how to remove the "line break" in user answer through the "replace" function?

[@maxvcollenburg]

Happy to hear it's useful! 🤗
I think you could use the replace function to replace 'linebreak' by 'emptystring'
So it would look like this;
replace(yourvalue;linebreak;emptystring)
Hope that helps!

[@ИванТищенко]

@@maxvcollenburg thanks for reply.
Yes, I see in the section the keywords "empty string" in the "Text and binary functions" tab, but I do not see the keyword "linebreak" there

[@maxvcollenburg]

@@ИванТищенко ah, sorry. It's called 'newline' I see 😋
So it would look like this;
replace(yourvalue;newline;emptystring)
Hope that works!

[@frankdemury4438]

is it possible find a space with indexOf?

[@rick_berga4830]

Is there any method to format text in italics or bold?

[@maxvcollenburg]

Yes, but it depends on where you use the italics & bold.
If you use it in an email, you can use for bold, and for italic.
Hope that helps!

[@wagnermonteiro3161]

Hey Max!
Great video, thanks!
I am trying to remove "space" and some symbols, sucha as ) ( - , from a telefone number filled in a form. Normally I do it trhough sending the phone number to a excel or google sheets, inputing the excel formula direct on Integromat. I would like to know if there is a better way to do it, directly with integromat.
Thank you!

[@maxvcollenburg]

Hey Wagner! Try searching for the "Phone number" app and use the "Parse a phone number" module.
That way, you get the phone number in all kinds of different formats. Including one without special symbols.
Hope that helps 🙃

[@danielattard]

Hi Max, Do you know if it is possible to use the Replace function to remove certain text (such as spaces and dashes) and replace it with nothing at all? I want to remove all spaces and dashes from my string before running my regex on it. Wondering if this can be done. Thanks.

[@maxvcollenburg]

Yes, you can replace whatever you want with the emptystring variable which you find at the text functions 😄

[@nadodigital]

Can you make text bold? I can't figure out how to make static text before a string bold.

[@maxvcollenburg]

Heyhey! It depends on the application where you're planning the text you want to have bold?
If you want to use it in an email module for example, you could HTML tags;
Hope that helps! 🤗

[@city3k5]

Hello,
I want to know if there is a way to use a dynamic variable in Integromat, then recall a variable (eg var1, var2, var3) using a repeater (x = 1 to 3) and use each time the value of the variable ("var" + x )
Thank you

[@maxvcollenburg]

Hey Daniele! I think you can use the set variable module.
Change the variable lifetime from one cycle to one execution, and you can use it! 😄

[@Chuletas9OS]

Hi Max, great video! Do you know how I can do to remove a comma from my text? I tried replacing it with "null", "erase", or leaving it empty but it keeps showing up. I used Replace function. Thanks Max!

[@maxvcollenburg]

Hey Pato! You're close!
You can use the replace function to get rid of with comma, just be sure to insert the emptystring variable 🙃

[@Chuletas9OS]

@@maxvcollenburg It works! Thank you very much Max!

[@maxvcollenburg]

@@Chuletas9OS great! Happy to hear it helped 🙃

[@D0J0Master]

Hello, Im trying to use the length to limit a string to only 6 digits, is this possible? Im struggling so much lol

[@maxvcollenburg]

Hey DoJo! Is it a number that you want to round up/down to 6 digits? Or does that not matter and do you only want to get the first/last 6 digits?

[@PaehBrian]

Hi, I have a question. I have a waiting list on my website and some people are making typos of .con instead of .com. Will the replace function work well here?

[@maxvcollenburg]

Hey Paeh! Yes, that should work!
I'm validating new leads with NeverBounce, and if the email address is invalid I check if they have one of the typo's below & replace it:
1️⃣ .om > .com
2️⃣ .con > .com
3️⃣ gamil.com > gmail.com
4️⃣ .xom > .com
5️⃣ .cmo > .com
Hope that helps!

[@PaehBrian]

@@maxvcollenburg okay thanks! I've tested it and it does work

[@maxvcollenburg]

@@PaehBrian great! 🙌

[@alsaukh3]

Very useful 👌

[@maxvcollenburg]

Glad you think so!

[@Overblazeinnitmate]

Hey Max, can we use any excel formulas in integromat?

[@maxvcollenburg]

Not that I know off, but the functions are rather similar.

[@lucvanquickelberge8763]

I want to remove ALL spaces in a string

[@maxvcollenburg]

I think you could use the replace function. Replace {{space}} by {{emptystring}} 🤓