cancel
Showing results for 
Search instead for 
Did you mean: 
schetti92
Nintex Newbie

How to extract words in Regular Expression action

Jump to solution

Hi Everyone,

Whats are the possible expressions to extract following data

 

<u>Date &amp; 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

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

Thanks is advance

Shashika

 

Labels: (1)
0 Kudos
Reply
6 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: How to extract words in Regular Expression action

Jump to solution

Hi,

 

I think it woul be simpler to just replace the text you dont need with blank text. I tested and it worked great.

2020-08-18 16_48_09-Workflow Designer - Internet Explorer.png

0 Kudos
Reply
schetti92
Nintex Newbie

Re: How to extract words in Regular Expression action

Jump to solution

Hi @SimonMuntz 

I'm getting the input from a email content (SharePoint plain text column)

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: How to extract words in Regular Expression action

Jump to solution
Whether you pull the imput from a column or hard code it the extraction process is the same.

Are you just pulling in Time Quote Required Back : 24-08-2020
or are you pulling in <u>Date &amp; Time Quote Required Back : 24-08-2020 </u>
0 Kudos
Reply
schetti92
Nintex Newbie

Re: How to extract words in Regular Expression action

Jump to solution

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 &amp; 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>

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: How to extract words in Regular Expression action

Jump to solution

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.

View solution in original post

0 Kudos
Reply
schetti92
Nintex Newbie

Re: How to extract words in Regular Expression action

Jump to solution

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.

0 Kudos
Reply