Removing Email address formatting for extraction and filling a custom field

Question

Hello!

I have a jotform set up to automatically populate the description of a Trello card with the form answers.  The first answer is an email address which shows up in the description formatted/clickable link.

I have an automation set up to extract that email address and populate it to a custom field where it is to be used by another automation.  However, when the automation pushed the email address to the Custom field it comes in the format

[example@abcd.com](mailto:example@abcd.com "‌")

My second automation that needs the email address from the custom field needs it as plain text eg.

example@abcd.com

Anyone know how to extract the email from the description as plain text?

Thanks in advance.

Oliver Rathonyi-Reusz · Answer

thank you - I also feel that is where the answer lies, but it's quite a learning curve.  If I get to the point where I can make something work, I will post it!

Renato Fagaraz · Answer

Hi, @Oliver Rathonyi-Reusz

It seems you're delving in a more advanced area of Automation, congrats!

For these, I'd recommend checking our Wildcards article, as they might help you find a condition to extract exactly the text of the email you're looking for https://support.atlassian.com/trello/docs/pattern-matching-and-wildcards/

As you might have noticed, wildcards are a basic level of using Regex (regular expressions) to match specific pieces of text. If you're looking for more complex matches I'd recommend looking for a Regex tutorial as that can prove to be an invaluable industry tool to have under your belt, and quite useful in situations like you're seeing.

Hopefully that helps!