Need to Extract the value of Highlighted Value from Mail Body

IF ORDERTYPE IS NPC THE SECTION BELOW SHOULD BE AUTOPOPULATED IN BAAN
BusinessSegment:6,6
SalesOrganization:84,84
AccountManager:1599,1599
SalesServiceOrganization:30,30
SalesServiceAccountManager: 1599,1599
Click the Save and exit button first button at top

IF TYPE IS NPC: Popup appears
IF TYPE IS NPC: Reason code:96 xit
IF TYPE IS NPC: click SAVE
IF TYPE IS NPC: click Exit

InventoryQtyReturned: always 1
Click the Save and exit button first button at top

Go back to the first screen and click the T on the header:
Click OK next to Header Text
Click Create
Enter Special Text (below) in the Text Editor window: 123 Text Edition

Click the File Menu, Select Save and Exit

Hi @Chaitan ,

Could you maybe check with the below regex :

(?<=Click Create.*\r?\n).*?:

Expression :

System.Text.RegularExpressions.Regex.Match(strText,"(?<=Click Create.*\r?\n).*?:").Value

image

If the Value corresponding to it is required then we could use below :

System.Text.RegularExpressions.Regex.Match(strText,"(?<=Enter Special Text \(below\) in the Text Editor window:).*").Value.Trim

image

Let us know if this is not the Expected Output and explain a bit more about the pattern or the condition or if there are any static keywords that we can anchor or refer.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.