How to store date in a variable by mail subject?

Help Studio
, ,
1

Hi team,
below mail subject in which i wanted to extract the date and store it in variable
Exchange rate w e f 15.08.2024

2

Hi @Naveen_Kanike

(\d+\.\d+\.\d+)

The image shows a regular expression tool highlighting a match for the date "15.08.2024" within the text "Exchange rate wef 15.08.2024". (Captioned by AI)
The image shows a regular expression tool highlighting a match for the date "15.08.2024" within the text "Exchange rate wef 15.08.2024". (Captioned by AI)1434×497 16.1 KB

Regards,

3

Hi @Naveen_Kanike

Ypu can use below assign syntax:

Str_date = System.Text.RegularExpressions.Regex.Match(currentMailMessage.Subject, "\d+\.\d+\.\d+").Value.Trim()

Regards

4

subject format will change but when i find date i need to store is it possible

5

@Naveen_Kanike

It will work if the date format fixed

6

@Naveen_Kanike

System.Text.RegularExpressions.Regex.Match(Input, "(\d+\.\d+\.\d+)").Value

The image shows a workflow with an "Assign" activity setting an input string, another "Assign" activity extracting a date using a regular expression, and a "Message Box" displaying the extracted date. (Captioned by AI)
The image shows a workflow with an "Assign" activity setting an input string, another "Assign" activity extracting a date using a regular expression, and a "Message Box" displaying the extracted date. (Captioned by AI)886×536 18.5 KB

7

data format will be allways dots i can control it.

8

@Naveen_Kanike

It will work…Try that

9

i am getting empty message box

10

Hie @Naveen_Kanike here the pattern you can use to get the date

The image shows a UiPath automation sequence with an "Assign" activity saving a value to "inputText" and an "Expression Editor" displaying a regex pattern to extract a date, alongside a message box showing the extracted date "15.08.2024." (Captioned by AI)
The image shows a UiPath automation sequence with an "Assign" activity saving a value to "inputText" and an "Expression Editor" displaying a regex pattern to extract a date, alongside a message box showing the extracted date "15.08.2024." (Captioned by AI)865×383 23.6 KB

System.Text.RegularExpressions.Regex.Match( inputText,“\b\d{1,2}[./-]\d{1,2}[./-]\d{2,4}\b”).Value

cheers

11

@Naveen_Kanike

Please check if the date is there or not in mail subject.
If date is not there in mail subject then it prints empty

12

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