cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dom_Stenson
New Member

Expression Assistance

Hi Guys,

 

I need an expression to get the 2 (or the first integer on the second line of email body text that has been converted from HTML).

 

I need something that will be like this is think, but I can't crack it.

 

first(skip(replace(split(variables('email_body'),' '),9)'success)',''))

 

Here is the text

51 Posterpay IPN searches, 45 Posterpay IPA passes (88.2% success)
2 Prodpay MPN searches

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User III
Super User III

Try this:

 

first(split(split(variables('email_body'), decodeUriComponent('%0A'))[1], ' '))

 

decodeUriComponent('%0A') represents a line break \n your email may have \n or it might have \r\n to represent a new line, if it does, use decodeUriComponent('%0D%0A') instead.

View solution in original post

2 REPLIES 2
Paulie78
Super User III
Super User III

Try this:

 

first(split(split(variables('email_body'), decodeUriComponent('%0A'))[1], ' '))

 

decodeUriComponent('%0A') represents a line break \n your email may have \n or it might have \r\n to represent a new line, if it does, use decodeUriComponent('%0D%0A') instead.

View solution in original post

That's Perfect Paulie, Thank You very much! 🙂

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (49,113)