Whats are the possible expressions to extract following data
<u>Date & Time Quote Required Back : 24-08-2020 </u> >>>> Get date['24-08-2020']
Has this been quoted previously? : No >>>> Get word ['No']
<br/> Probability of winning quote (%) : 50 >>>> Get Number 
Note : I tried following, but its not working
Thanks is advance
Solved! Go to Solution.
This is the sample email column
need to extract the Date, Customer Name and winning quote (%)
<div> Dear Team,
<h1>Please check the below details</h1>
<u>Date & Time Quote Required Back : 24-08-2020 </u></h4> Has this been quoted previously? : No
<u>Quote Details</u></h3> Test name : Qpac - Stage 7
<br/> Customer name : Test Customer
<br/> Customer acc no : 23
<br/> Customer contact name : Test Name
<br/> Customer email : firstname.lastname@example.org
<br/> Quote phase (Urgent Action/Live Job/Tender) : Tender - If we need to delay the quote return date please advise
<br/> Project Size : Medium Project
<br/> Probability of winning quote (%) : 50
<u>Margin/Pricing</u></h4> Switchboard components pricing(B1/B2/G1) : B1
<br/> Best Regards
<br/> Sales Team
I had another look at this.
What I did was input all the HTML.
Then split it via the < character into a collection variable.
Then ran the collection variable through a For Each action looking for the part that you needed.
Once found I used another regular expression to trim out the unwanted text and just keep the date.
You could use the same concept to extract the other information you require.
Please see the sample workflow attached.
Thanks for the prompt reply and the solution. This method dose the job for me. I had to use another regular expression inside the foreach action to remove special characters.