How split a string with email addresses into an array

(0) Share

Report

Posted on by PatrizioB

Hi , i need to extract the email addres into a string like that

"tom@contoso.com, joe@acme.net, tim@contoso.com"

into an array

{

tom@contoso.com

joe@acme.net

tim@contoso.com

}

in order to apply a for each on the array

Any help is very appreciated, thank YOU!

Categories:

General topics

All responses (7)

Answers (0)

Sort by

VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Use split function.
PatrizioB 14 on at

Like
a
(0)

Report
Copy link

Link copied!

sorry, i've written too "simple" my question..
I need to extract all the recipient from a "export mail V2" function .
I have to get all the chars after "To: " , extract only the email address and put them into an array
Can you help me ?
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you show your flow?
PatrizioB 14 on at

Like
a
(0)

Report
Copy link

Link copied!

1) found the index of "To: "from the export mail
iniziorigagrezza = indexOf(outputs('Export_email_(V2)')?['body'],'To: ')
2) get 2500 chars from the "To: " rigadest = substring(outputs('Export_email_(V2)')?['body'],variables('iniziorigagrezza'),2500)
3) remove the "To: " from the string rigadestpulita = replace(variables('rigadest'),'To: ','')
4) i'm there ... I need to find a way to extract only emailaddresses from "rigadestpulita"

thank you
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Why did you decide that 2500 is the right length of substring?
You have to find first CRLF combination after To: to get the string of addresses.
After that you can use split function to get the array.
PatrizioB 14 on at

Like
a
(0)

Report
Copy link

Link copied!

ok i've fixed the 2500 char issue and set it to CRLF , now how can i split from a string like that ?
"nadya.volk@crvd.net, Tom Pat <tom.pat@crvd.net>"
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Initialize the variable of type array with this expression:
split(variables('var1'),',')