Extract Date out of text

[kaurM]

How would you extract date out of this text?

@“Monthly letter: Random text
2024-07-09
collapsed”

Text is varying but date would always be in the format yyyy-MM-dd.

[loginerror (Maciej Kuźmicz)]

Hi @kaurM

Have you tried this activity?

Activities - Extract Date and Time from Text

[kaurM]

Thank you!
Unfortunately, My studio version (2022.10.4) doesn’t let me update the UiPath.System.Activities package.

[ppr (Peter Preuss)]

@kaurM

Monthly letter: Random text
2024-07-09
collapsed

Regex for the value:

Assign Activity:
strDate =

System.Text.RegularExpressions.Regex.Match(yourStringVar,"\d{4}-\d{2}-\d{2}").Value

Parsing into datetime:

DateTime.ParseExact(strDate,"yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)

[postwick (Paul Ostwick)]

System.Text.RegularExpressions.RegEx.Match(inputString,“\d\d\d\d-\d\d-\d\d”)

[vrdabberu (Varunraj Dabberu)]

Hi @kaurM

Please try the below syntax:

Input = "Monthly letter: Random text
2024-07-09
collapsed"

Output = System.Text.RegularExpressions.Regex.Match(Input, "\d+\-\d+\-\d+").Value.Trim()

Regards

[kaurM]

Thank you
Your solution worked