Extract date like strings from long string

Hi all,

I have a question regarding the formatting of a long string through regex expressions. I have no expirience with this. I always worked my way around with normal string formatting. For this case however, I think regex would be the best solution. I have a string that looks like this:

Spain: AG342123, Madrid 29.06.2020, RM 43, IS432423, 123432334, BCN Seaet, Madrid, BLAHBA, Germany: IS343214, Barcelona 03.11.2019, TE 34, etc…

I would like to extract all date like formats. In this case “29.06.2020” and “03.11.2019”.

I have tried with splitting and substring but it won’t work since the string length and placement is not constant

Thanks a lot in advance,
chusi

Is the date format same i.e. dd.mm.yyyy ?

yes, always this format

Try this regex

Thanks

1 Like

works perfect. Thanks a lot @hasib08

1 Like

@chusikowski

Use Matches Activity and give you string, like below

Mark as solution if this helps

Thanks

1 Like

Check out my post if you want to learn more about Regex

1 Like

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