Hi. I have an outlook mailbox mensage in the following format:
Email notification!
text1/ text2 / text3/ text4
Thank you for using our Plataform!
How can i extract:
text1
text2
text3
text3
Thank you for your support
Solved! Go to Solution.
Hey @Davidn7
I have a solution for you if the body of the email remains static always like the above case.
Do the following:
First use html to text action:
Take a string variable with empty line:
After that use the following expression in a compose:
split(split(replace(outputs('Html_to_text')?['body'],'/',''),variables('A'))[2],' ')
Firstly I have done replace to remove the / slash. After that I am splitting whereever it finds an extra line. So while using the html to text an extra line comes. After that I am using another split to just take out the text values.
You can also use separate compose actions and expressions as well:
Separate expressions:
replace(outputs('Html_to_text')?['body'],'/','')
split(outputs('Compose_2'),variables('A'))
split(outputs('Compose_3')[2],' ')
Final Output:
Hey @Davidn7
I have a solution for you if the body of the email remains static always like the above case.
Do the following:
First use html to text action:
Take a string variable with empty line:
After that use the following expression in a compose:
split(split(replace(outputs('Html_to_text')?['body'],'/',''),variables('A'))[2],' ')
Firstly I have done replace to remove the / slash. After that I am splitting whereever it finds an extra line. So while using the html to text an extra line comes. After that I am using another split to just take out the text values.
You can also use separate compose actions and expressions as well:
Separate expressions:
replace(outputs('Html_to_text')?['body'],'/','')
split(outputs('Compose_2'),variables('A'))
split(outputs('Compose_3')[2],' ')
Final Output:
User | Count |
---|---|
25 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
48 | |
29 | |
28 | |
25 | |
23 |