Since English is the official language of the community, I’m gonna go ahead and paste a DeepL translation of your question below.
I need to extract variable information from the body of e-mail received via Mailhook.
I receive information from Leads via email, and need to extract only the Lead information (Name, Email and Phone) to a spreadsheet.
I used the Text Parser function (Match Elements) to extract the data from the body of the email. I am extracting data from the HTML of the email and throwing it into a spreadsheet.
The E-mail and Phone fields worked fine, because they are already pre-configured. But the name field, is pulling together the name of the field and I need only the variable as below.
It is pulling this information:
Name: Customer Name
And I need just the information below:
How do I delete the information "
" and throw in the spreadsheet only the information “Customer Name”?
Someone can help me, I’m new to integromat and I’m not a programmer I’m having difficulties, if someone can point me to a video with this solution thank you!
Thanks for the tip, but as I don’t understand code (I’m still learning) it didn’t work.
I tried to use the code you provided (?<=City:\s?)(.), being that I changed City: for Name: so that I entered (?<=Nome:\s?)(.) but unfortunately it didn’t work.
In Mailhook, I get the data in the email body with the layout below.
Chegou um novo lead
Data de nascimento: 07/09/1999
Empreendimento: BELLA VENEZA
From these fields, I need to extract the Name, E-mail and Telephone to my spreadsheet.
I used the Text Parser function and managed to correctly extract the E-mail and Phone, but the name I’m getting in the spreadsheet the information like this:
but I only needed to receive: Maike
In the field Delimiter: I filled in the information Nome:
Do you know how I should put it in this case so that the name field comes with just the name, without these additions?