Extract dates with Regex

I have the structure bellow :

Arrival Date Friday, 21 May 2021 (from 12:00)
Departure Date Saturday, 22 May 2021 (until 10:00)

and I’m looking to extract dates, without the name of the day, as follow:
first Regex code: 21 May 2021
second Regex code: 22 May 2021

I’ve tried this but I’m able to extract the first line only:
/(?<=,\s)\d{2}\s\w+\s\d{4}/gmi
*anyway, the code is low

Thanks.

@IPIX - Here you go…

image

(?<=Arrival\s+Date.*\,\s+).+(?=\s+\()

Departure Date

image

(?<=Departure\s+Date.*\,\s+).+(?=\s+\()
1 Like

I’ve got “pattern error” in regex101.com but it work well in regextester.com.
I’ll try later on in my code in UIpath. Then I’ll let you know.

Thanks a lot!

Nope…its good…Make sure you have to choose ECMA script option on your left which is closest to UiPath…

https://regex101.com/r/9oUADE/2
https://regex101.com/r/9oUADE/1

Tested, it works like a charm. I’ll try to recompose in order to learn how you’ve done it.
Thanks also for point out ECMA setting.

Cheers!

1 Like

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