Regex Date help

Help Activities
, ,
1

Hi,
I need to grab Closing Date or Preview Date “May 25, 2023” or “02/04/2024” or “03/02/2024” from the following patterns. Can you please help? Thank you!

Closing Date: May 25, 2023

Closing Date 2:55 pm, May 25, 2023 Next Open Date: 6/25/2023

Preview Date 02/04/2024 3,571.29 CR

Preview Date 03/02/2024

2

Hi @A_Learner

For “May 25, 2023” format:

[A-Za-z]+ \d{1,2}, \d{4}

For “02/04/2024” or “03/02/2024” format:

\d{2}/\d{2}/\d{4}

Regards,

3

Hi @A_Learner

\b(?:\d{1,2}/\d{1,2}/\d{4}|[A-Za-z]{3,9} \d{1,2}, \d{4})\b

image
image1175×458 33.4 KB

Hope it helps!

4

Thank you @pravallikapaluri
Is there a way to avoid getting Next open date.

Thanks again

5

@A_Learner

(\w+ \d{1,2}, \d{4})|(\d{2}/\d{2}/\d{4})

image
image1076×532 24.8 KB

1 Like
6

@A_Learner

Please find the below regex expression

([A-Z]+[a-z]+\s?\d+\,?\s+\d+)|(\d+\/\d+\/\d+)

image
image1096×498 26.2 KB

Hope it works!!

7

Hey @A_Learner,

Here is a generic date regex,
((January|February|March|April|May|June|July|August|September|October|November|December) \d*, \d{4})|(\d{2}/\d{2}/\d{4})

image
image877×529 44.1 KB

8

@A_Learner

You can use the below regex if you want to avoid the open date

([A-Z]+[a-z]+\s?\d+\,?\s+\d+)|(\d{2}\/\d+\/\d+)

image
image1426×499 31.4 KB

Regards

1 Like
9

@A_Learner

Thank You

Happy Automation !!

10

Thank you @vrdabberu

Thank you, every one for the education on Regex.

11

If Possible, can you please explain a little bit about the regex before |
I get the second part okay. Many Thanks,

12

Some good sites are:

  1. https://regex101.com/ - To test regex patterns or create
  2. Regex Tutorial | Regular Expression - Javatpoint - To understand regex symbols
13

@A_Learner

I have been considering the month over there and in this case its may and in other case it might be some other month so that’s the reason I have given

[A-Z]+ this consider the capital letters and + indicates 1 or more alphabets
[a-z]+ this consider the small letters and + indicates 1 or more alphabets
\s+ this represents the space and here + represents 1 or more spaces can be there
\d+ this consider the digits and + indicates 1 or more digits
,? this represents the , and the ? mark represents that the character before the question mark
can be considered or not means it can be there or not there and ? represents 0 or 1 character
\s+ this represents the space and here + represents 1 or more spaces can be there
\d+ this consider the digits and + indicates 1 or more digits

Regards

14

Thank you for your time.

15

Thank you @Quenton_Wayne_Rebello

1 Like
16

I am trying look behind for this, that is match this date pattern only with Closing Date or Preview Date etc. It is not working. Can you help? Below is the regex I am trying to use.

(?<=Preview Date )([A-Z]+[a-z]+\s?\d+,?\s+\d+)|(\d{2}/\d+/\d+)

Thank you,

17

@A_Learner

image
image1420×569 31.8 KB

It works for me please check once

18

@A_Learner

it will not work if you give a preview date over there.

(?<=Preview Date )([A-Z]+[a-z]+\s?\d+,?\s+\d+)|(\d{2}/\d+/\d+)

Please remove this (?<=Preview Date ) i haven’t included it in my regex code

just use this and don’t add anything

([A-Z]+[a-z]+\s?\d+\,?\s+\d+)|(\d{2}\/\d+\/\d+)

Regards

19 
(?:Closing Date: )?(?:Preview Date )?((?:[A-Z][a-z]+\s\d{1,2},?\s\d{4})|(?:\d{2}\/\d{2}\/\d{4}))

Explanation of the regex pattern:

  1. (?:Closing Date: )?: This part is for the optional “Closing Date:” prefix.
  2. (?:Preview Date )?: This part is for the optional “Preview Date” prefix.
  3. (: Start of the capturing group.
  4. (?:[A-Z][a-z]+\s\d{1,2},?\s\d{4}): This part matches the date in the format “May 25, 2023”. It allows one uppercase letter, one or more lowercase letters, followed by one or two digits for the day, an optional comma, and four digits for the year.
  5. |: The vertical bar acts as an OR operator.
  6. (?:\d{2}\/\d{2}\/\d{4}): This part matches the date in the format “02/04/2024” or “03/02/2024”. It allows two digits for the month, two digits for the day, and four digits for the year.
  7. ): End of the capturing group.

The regex pattern captures the dates in the provided formats, whether they are “Closing Date:” or “Preview Date” and extracts them as groups. You can use this pattern in a programming language or tool that supports regular expressions, such as Python, JavaScript, or any other language that UiPath supports for text manipulation.

20

Thank you @SwathiPuli for your time in explaining!!