email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
I am pasting in the contents from two emails and the body text from parser. In the first email, the parser text is displaying the link text and the hyperlink text for "Unit Desired Url:". It also does this in the 2nd link for "City: Two Harbors" but it does not seem to do this for every link (i.e. "Url:" in 2nd email). How do I retain the hyperlink text but remove the hyperlink itself ?

Examples pasted below:
*********************
Email 1 Original text:
--------------------------------------------------------------------------------------------------------------------
To Duluth Lawn & Sport,

A new value trade request was submitted from your website
https://www.duluthlawnandsport.com/ on 04/17/2018 at 10:31 AM.

First Name: duane
Last Name: dallum
Email Address: john@smith.com
Phone:
Unit Desired Year:
Unit Desired Make: John Deere
Unit Desired Model: X360
Unit Desired Price: 2695.00
Unit Desired Url:
https://www.duluthlawnandsport.com/-1-john-deere-x360-inventory.htm?id=2143524&in-stock=1
Trade Vehicle Year: 2012
Trade Vehicle Make: can am
Trade Vehicle Model:
Trade Vehicle Usage:
Trade Vehicle Accessories Added:
Comments:
Receive offers: No
--------------------------------------------------------------------------------------------------------------------
Email 1 Body text from Parser
--------------------------------------------------------------------------------------------------------------------
To Duluth Lawn & Sport,
A new value trade request was submitted from your website
https://www.duluthlawnandsport.com/ on 04/17/2018 at 10:31 AM.
First Name: duane
Last Name: dallum
Email Address: john@smith.com
Phone:
Unit Desired Year:
Unit Desired Make: John Deere
Unit Desired Model: X360
Unit Desired Price: 2695.00
Unit Desired Url:
https://www.duluthlawnandsport.com/-1-john-deere-x360-inventory.htm?id=21435
24
<https://www.duluthlawnandsport.com/-1-john-deere-x360-inventory.htm?id=2143
524&in-stock=1> &in-stock=1
Trade Vehicle Year: 2012
Trade Vehicle Make: can am
Trade Vehicle Model:
Trade Vehicle Usage:
Trade Vehicle Accessories Added:
Comments:
Receive offers: No
--------------------------------------------------------------------------------------------------------------------
Email 2 Original text:
--------------------------------------------------------------------------------------------------------------------
To Duluth Lawn & Sport,

A new request for a quote was submitted from your website
https://www.duluthlawnandsport.com/ on 04/07/2018 at 5:06 PM.

First Name: bryan
Last Name: Lundberg
Address 1: 1715 9th Ave
City: Two Harbors
Region: Minnesota
Postal Code: 55616
Country: United States
Phone: 2183404695
Email: paul@shoemakerplace.com
Manufacturer: Polaris Industries
Product: 2017 Polaris Industries RANGER XP(r) 900 Sage Green
Model Description: RANGER XP(r) 900 Sage Green
Year: 2017
Price: $12,299.00
Color: sage green
Purchase Time frame: 3 Months
How did you find our website?: Word of mouth
Url:
https://www.duluthlawnandsport.com/2017-polaris-industries-ranger-xp-900-sage-green-inventory.htm?id=24067337
Comments: Hi there, Can you me todays price on this model? looks like the
2017 and 2018s are the same price. Please email only.
--------------------------------------------------------------------------------------------------------------------
Email 2 Body text from Parser
--------------------------------------------------------------------------------------------------------------------
First Name: bryan
Last Name: Lundberg
Address 1: 1715 9th Ave
City: Two Harbors
<https://maps.google.com/?q=1715+9th+%0D%0AAve+City:+Two+Harbors&entry=gmail
&source=g>
Region: Minnesota
Postal Code: 55616
Country: United States
Phone: 2183404695
Email: paul@shoemakerplace.com
Manufacturer: Polaris Industries
Product: 2017 Polaris Industries RANGER XP(r) 900 Sage Green
Model Description: RANGER XP(r) 900 Sage Green
Year: 2017
Price: $12,299.00
Color: sage green
Purchase Time frame: 3 Months
How did you find our website?: Word of mouth
Url:
https://www.duluthlawnandsport.com/2017-polaris-industries-ranger-xp-900-sag
e-green-inventory.htm?id=24067337
Comments: Hi there, Can you me todays price on this model? looks like the
2017 and 2018s are the same price. Please email only.
Hi Paul,

You can try doing the parsing in two steps. In the first one you get all the text as it comes. For example:


https://www.duluthlawnandsport.com/-1-john-deere-x360-inventory.htm?id=2143524
<https://www.duluthlawnandsport.com/-1-john-deere-x360-inventory.htm?id=2143524&in-stock=1> &in-stock=1

And in the second step you get the link text using the previous step result (not the original email body) as input. I have attached some screenshots.
Attachments
1.png
1.png (88.64KiB)Viewed 636 times
2.png
2.png (48.39KiB)Viewed 636 times