+2
Hi Everyone,
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 [50]
Note : I tried following, but its not working
Thanks is advance
Shashika
+22
Hi,
I think it woul be simpler to just replace the text you dont need with blank text. I tested and it worked great.
+2
Hi @SimonMuntz
I'm getting the input from a email content (SharePoint plain text column)
+22
+2
This is the sample email column
need to extract the Date, Customer Name and winning quote (%)
<div class="ExternalClassC92F283FFFB647598431BD078702EC4F">
<div> Dear Team,
<h1>Please check the below details</h1>
<h4>
</h4>
<h4>
<u>Date & Time Quote Required Back : 24-08-2020 </u></h4> Has this been quoted previously? : No
<br/>
<h3>
<u>Quote Details</u></h3> Test name : Qpac - Stage 7
<br/>
<br/> Customer name : Test Customer
<br/>
<br/> Customer acc no : 23
<br/>
<br/> Customer contact name : Test Name
<br/>
<br/> Customer email : test.test@test.com
<br/>
<br/> Quote phase (Urgent Action/Live Job/Tender) : Tender - If we need to delay the quote return date please advise
<br/>
<br/> Project Size : Medium Project
<br/>
<br/> Probability of winning quote (%) : 50
<br/>
<br/>
<h4>
<u>Margin/Pricing</u></h4> Switchboard components pricing(B1/B2/G1) : B1
<br/> Best Regards
<br/> Sales Team
</div>
+22
Hi,
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.
+2
Hi @SimonMuntz
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.