My data looks like this:
Column1
, m. 05/31/2022
, m. 01/12/2021
, m. 09/12/2022
I need a regex command that splits this into 2 capture groups: 1. ", m. "
2. "09/12/2022"
I tried this expression ([,\s m.])(\d{2}\/\d{2}\/\d{4}) but it gives me only the date from the 2nd capture group. Nothing captured from the first group. Any ideas?
Solved! Go to Solution.
Nevermind, got it. It should be (\,\s\w\.\s)(\d{2}\/\d{2}\/\d{4})
In this case you could also use the below
(.+)(\d{2}\/\d{2}\/\d{4})