Parsing Email Body for specific values

[Trebarne]

I am trying to create a automated task where once a email is received, The contents of the body are extracted and put into values for each appropriate property

This is what each email that is received will be formatted as 

Welcome to Super View Test
Please login to your account using the details below

Username: Tbqa6@superviewexample.com
Temporary password: 580bee1f
URL: https://qa2.superviewexample.com

Registration Details submitted:

First Name: Test
Last Name: IOS
Phone Number: undefined
Company: IOS Test 1

And I believe this is what it will be formatted as in HTML to Text 

<p>Welcome to Super View Test Please login to your account using the details below</p>

<p>Username: Tbqa6@superviewexample.com Temporary password: 580bee1f URL: https://qa2.superviewexample.com</p>

<p>Registration Details submitted:</p>

<p>First Name: Test Last Name: IOS Phone Number: undefined Company: IOS Test 1</p>

I would like to be able to extract Username and populate the property email, First Name populates the firstname property, Last Name  populates the lastname property, Phone Number populates the phone number property and Company populates the company property.

This is the flow That I have so far and I am not entirely sure  if this is the best way to go about this. Any feedback would be appreciated here.

[Paulie78]

Ideally you would post a sample of the html email received here (before it has been converted to text). And a list of every property you want to extract.

Be sure to use the Insert/edit code sample button in the toolbar before posting the HTML.

[Trebarne]

Thanks for the Feedback Paulie! I have edited the question to include all the properties I want and I believe  I have inserted what I believe the HTML of the Email will render as.

[Paulie78]

ok, I've sort of built your answer already, but these questions/solutions are highly dependant on the input being consistent etc. That is why I asked for the HTML input of the email. Based on what you have written above I still have the same concern. Your HTML example of:

<p>Welcome to Super View Test Please login to your account using the details below</p>

<p>Username: Tbqa6@superviewexample.com Temporary password: 580bee1f URL: https://qa2.superviewexample.com</p>

<p>Registration Details submitted:</p>

<p>First Name: Test Last Name: IOS Phone Number: undefined Company: IOS Test 1</p>

produces output nothing like what you have suggested the output is of: 

Username: Tbqa6@superviewexample.com
Temporary password: 580bee1f
URL: https://qa2.superviewexample.com

Registration Details submitted:

First Name: Test
Last Name: IOS
Phone Number: undefined
Company: IOS Test 1

So, which one is accurate? If that what is the output of the HTML to Text action looks like, I will give you a solution that works for that. But it would totally not work if the HTML input was like the example you have suggested, Are you following me?

[Trebarne]

Sorry for the confusion here. So my output will be same every time for every email that is received.  I went ahead and tried to reverse engineer one of the emails that I have received  and use a text to HTML generator and I received  this 

<p>Welcome to Super View Test Please login to your account using the details below</p>

<p>Username: Tbqa6@superviewexample.com Temporary password: 580bee1f URL: https://qa2.superviewexample.com</p>

<p>Registration Details submitted:</p>

<p>First Name: Test Last Name: IOS Phone Number: undefined Company: IOS Test 1</p>

So I believe this is what will be outputted in my HTML to text  flow. I apologize I am still fairly new to this.

[Paulie78]

Go into your run history, click on the HTML to Text action and look at the "Inputs" section. This will contain the source HTML which I need to accurately recreate your scenario.

[Trebarne]

So I don't have to any example runs/history as of yet as there has not been any emails. Sorry I was not prepared as I should of been for this. I am trying to get generate some run history now and trigger the job