I have a series of dates that I am trying to separate into years, months and days. These dates are in the yyyy-mm-dd format. I'm not very familiar with RegEx, but I have tried (\dddd)\-(\dd)\-(\dd).
Any help is appreciated.
Asked
Active
Viewed 43 times
-1
-
What means - *"to separate* `yyyy-mm-dd` *into years, months and days"*? – Roko C. Buljan Jan 28 '19 at 22:38
-
1I am trying to parse the years, months and day of each cell into its own cell. The accepted answer from Engineero did the trick. – Brad Lee Jan 28 '19 at 22:48
-
`d` matches `d`, `\d` matches digits. – Wiktor Stribiżew Jan 28 '19 at 23:06
1 Answers
0
Accepted answer would also match invalid dates like 1234-56-78, or if mm & dd were in the wrong positions.
([1-2][0-9]{3})\-([0-1][0-9])\-([0-3][0-9])
Does a little more validation.
stever
- 1,168
- 2
- 11
- 20