Delete spaces from Email adress

How To
1

I’d like to delete all the spaces in an email when adding it to a google sheet,

for example: transform “test@ mail. com” into “test@gmail.com”.

What function and how should I use it in the mapping?

2

Welcome to the Make community!

To do this, you can use the built-in function replace —

{{ replace(text; search string; replacement string) }}

e.g.: (paste this into the field)

{{ replace(1.text; space; emptystring) }}

For more information, the function’s documentation can be found in the Help Centre. You should also complete the tutorials in the Make Academy.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.