#17 : No-Code Apps & Tutorials (GoogleSheet)
Create an ebook in minutes, have your text read by Morgan Freeman, capture info & websites in MeM and more
A long week for us, we are building new apps & products right now, for noCoders !
I will give you some info in the next newsletter !
APPS of the Week #17
#1 - Designrr.io - Generate ebooks with any content
One of my favorite apps this week, it’s a pretty good deal ($27 lifetime) if you like to write articles and ebooks, it’s so easy to generate a lead magnet in minutes.
Import your blog, an article, or anything and they will format the ebook for you.
They also did an article about ebook creation here
#2 - Mem
Mem is the fastest way to capture, share and use information.
They form relationships between the information you capture, generate relevant - sometimes unexpected - insights.
#3 -AI Voice Generator & Realistic Text to Speech Online
They are also building a new voice cloning engine => Check this tweet
#4 - Magic Eraser - Use AI to remove unwanted things from images in seconds
Just erase unwanted items on any picture.
QUICK TUTORIAL (REGEX and Google Sheet)
1. DELETING CHARACTERS
To remove all non-numeric characters (to keep only phone numbers, for example), enter the regex "\D"
and replace those characters with an empty string ""
:
=REGEXREPLACE(A2;"\D";"")
2. REPLACE EMAIL ADDRESSES
The following formula is used to detect and replace email addresses (this regex is detailed in one of the examples of the REGEXMATCH function):
=REGEXREPLACE(A2;"[\w.-]+@[\w.-]{2,}\.[a-z]{2,}";"[remove email]")
To remove only the first part of the email address and replace it with "xxxxxx", enclose the second part to be retained in parentheses and add it to the replacement email address using $1 :
=REGEXREPLACE(A2;"[\w.-]+(@[\w.-]{2,}\.[a-z]{2,})";"xxxxxx$1")
$1 returns the value of the first pair of brackets, $2 returns the value of the second pair of brackets and so on.
That’s it ! Oh, You can find us on twitter now !
See you next week !