Hi guys,
Could you help me write the correct pattern for getting the email adress correctly pleas? Thanks a lot!
Hey @augustinb , you can use something like this:
(?<=mailto\:)(.+?)(?=\|)
Looks like this:
Next time, adding the email and such as text helps a lot more (then people can just copy paste it 
).
1 Like
Hi. If you do not want fire a step you can use it direclty in the mapped mail field:
{{replace(replace(“mailto:address@mail.com”; “<mailto:”; emptystring); “>”; emptystring)}}
If you need additional support, please don’t hesitate to reach out.
Cheers
//HFBR
1 Like
Thanks a lot!
good to know, sorry I am new here 
2 Likes
No problem @augustinb ! 
Let me know if you need any other assistance
1 Like
Heya @augustinb welcome to the community 
I see that Bjorn’s comment 
helped point you in the right direction, that’s awesome 
In case it is the ultimate answer to your question, could you please 
mark the reply as a solution?
It helps keep the community space tidy 
Thanks a lot!
Hey Bjorn, I am not sure it works correctly for me.
I have this json code, from which i want to extract email, gender and name (in bold in the json).
I use the text parser module. Pattern is: (?<=mailto:)(.+?)(?=|)\ngenre: (?.)\nnom: (?.)
Text is: {{get(map(get(map(16.attachments; “fields”); 1); “value”; “title”; “Balises”); 1)}}
Thanks a lot for your help
JSON INPUT
[
{
“type”: “message”,
“subtype”: “bot_message”,
“text”: “Bonjour Augustin \nUn nouveau traitement est disponible sur la plateforme Dataleon 
\n\n”,
“ts”: “1674030628.668739”,
“bot_id”: “B04H77L1Y6N”,
“blocks”: [
{
“type”: “rich_text”,
“block_id”: “OYcl”,
“elements”: [
{
“type”: “rich_text_section”,
“elements”: [
{
“type”: “text”,
“text”: "Bonjour Augustin "
},
{
“type”: “emoji”,
“name”: “wave”,
“unicode”: “1f44b”
},
{
“type”: “text”,
“text”: " \nUn nouveau traitement est disponible sur la plateforme Dataleon "
},
{
“type”: “emoji”,
“name”: “rainbow”,
“unicode”: “1f308”
}
]
}
]
}
],
“attachments”: [
{
“id”: 1,
“footer_icon”: “https://uploads-ssl.webflow.com/6263ca4a5e32dab07539b0d3/6265c047776abb1a6c73cb71_6185a98d92e40f90970cf969_favicon.png”,
“ts”: 1674030628,
“color”: “4ee662”,
“fallback”: “[no preview available]”,
“author_name”: “dataleon”,
“author_link”: “https://dataleon.ai/”,
“author_icon”: “https://uploads-ssl.webflow.com/6263ca4a5e32dab07539b0d3/6265c047776abb1a6c73cb71_6185a98d92e40f90970cf969_favicon.png”,
“footer”: “Dataleon Platform”,
“fields”: [
{
“value”: “0e053ec1-5aae-40e6-bc33-a835321bca20”,
“title”: “ID”,
“short”: false
},
{
“value”: “Bank statements v4”,
“title”: “API”,
“short”: true
},
{
“value”: “Mon espace ”,
“title”: “Espace de travail”,
“short”: true
},
{
“value”: “TRAITÉ”,
“title”: “Statut”,
“short”: true
},
{
“value”: “1s”,
“title”: “Temps de traitement”,
“short”: true
},
{
“value”: “0”,
“title”: “Nombre de documents”,
“short”: true
},
{
“value”: “0”,
“title”: “Nombre de pages”,
“short”: true
},
{
“value”: “Augustin BELLET”,
“title”: “Utilisateur”,
“short”: true
},
{
“value”: “”,
“title”: “Catégorie”,
“short”: true
},
{
“value”: “email: <mailto:augustinbellet0@gmail.com|augustinbellet0@gmail.com>\ngenre: Monsieur\nnom: Bellet”,
“title”: “Balises”,
“short”: false
},
{
“value”: “<https://console.dataleon.ai/fr/wks/wk_k7KlVpHTZ4/dashboard/analytics/0e053ec1-5aae-40e6-bc33-a835321bca20/document/0e053ec1-5aae-40e6-bc33-a835321bca20/document|Accéder à la plateforme>”,
“title”: “Lien”,
“short”: false
}
]
}
],
“date”: “2023-01-18T08:30:28.000Z”
}
]
Thanks for your answer, the problem is that I need other data (text) from the input json code.
Hey @augustinb , this should work for you.
(?<=mailto:)(.+?)(?=\|)|(?<=\\ngenre\: )(.+?)(?=\\)|(?<=\\nnom\: )(.+?)(?=\”)
If you want all bundles to be together again, use an array aggregator after the text parser to put it all in an array:
1 Like