Extract desired text from String

Help Studio
1

Team,
Can anyone suggest from string extraction as below :

Input -
Subject :PEX Job Failed Verify PRODUCTION 14562734 Body :Z0640702N.20221109.d01.20221109.010042.PR1.PRN.ps has failed

Job Received: 2022-11-09 06:27:00.02
Statement Type: d01_Statement
Client ID: Z0640702

Client Name: First Montana Bank 063 - 102882

Output -
14562734

2

Hi @prerna.gupta

Please use String left/right activity if value required is between production and body always

cheers

3

HI @prerna.gupta

Checkout this expression

System.Text.RegularExpressions.Regex.Match(StrVariable,"\d+(?=\sBody)").ToString

image
image796×372 27.6 KB

Where StrVariable = Your input
Regards
Sudharsan

1 Like
4

HI @prerna.gupta

How about this expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=PRODUCTION\s)\d+").Tostring

image

Regards
Gokul

5

Thanks much.

6

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