Need help in getting date from string

Help StudioX
,
1

Job Complete Date changed from 12/31/21 00:00 to 12/31/22 00:00 for Job Number A01Z6B4 on Work Request 05789494

Above is the string format and i need to get the date which is the latest one i mean after to. how to get this date.

2

HI @Puneet_Singh3

Use assign activity

LHS → Create an variable
RHS → System.Text.RegularExpressions.Regex.Match("Input String","(?<=to\s)(\d.{2}\d.{2}\d{2})").Tostring.Trim

image
image914×207 12.1 KB

Regards
Gokul

3

If you need to get Date and Time

Try with this expression

Use assign activity

LHS → Create an variable
RHS → System.Text.RegularExpressions.Regex.Match("Input String","(?<=to\s)(\d.{2}\d.{2}\d{2}\s\d+:\d+)").Tostring.Trim

image
image936×190 12.9 KB

Regards
Gokul

4

Getting Blank

image
image1920×1080 172 KB

5

Can you share exact Input text @Puneet_Singh3

6

Hi can you show the XAML file screenshot.

In think so there is Whitespace between the data share exact input to provide the expected output @Puneet_Singh3

Regards
Gokul

7

Job Complete Date changed from 10/30/21 15:00 to 06/30/22 00:00 for Job Number A024SH4 on Work Request 05865714

This is the exact input text which i get and i need to extract date and work request

8

Use assign activity

LHS → Create an variable
RHS → System.Text.RegularExpressions.Regex.Match("Input String","(?<=Work\sRequest\s)(\d+)").Tostring.Trim

image
image1303×241 17.7 KB

Regards
Gokul

9

Not working

image
image1920×1080 154 KB

10

Can you share the mail subject here @Puneet_Singh3

11

Hi @Puneet_Singh3

System.Text.RegularExpressions.Regex.Match(MailSubject,“(?<=Work\sRequest\s)(\d+)”).Tostring.Trim

MailSubject → Variable You don’t need to put in Double quotes

Regards
Gokul

12

@Puneet_Singh3

Try This :

regex.Match(Test,“(?<=to )[\d]{2}.[\d]{2}.[\d]{2}”).ToString
Screenshot (121)