Splitting date regex

Question

Hi I'm trying to split the format of the date YYYY-MM-DD to seperate variables in yahoo pipes.

I can get the regex working for the year but I'm struggling with getting the month and day.

My regex for year:

(?<=\d{4}).*

Yahoo pipes uses the replace regex I think, so I would need to select the year-(skip)-day to get the month. Any help would be appreciated.

score 0 · Answer 1 · answered Apr 22 '12 at 23:43

0

The regex (\d{4})-(\d{2})-(\d{2}) matches and captures the elements of the date. I'm not sure how you'd use this in Yahoo Pipes, since I've never used it myself, but the regex should help you there.

answered Apr 22 '12 at 23:43

Niet the Dark Absol

320,036
81
464
592

I need to create a seperate regex rule for each variable so (?<=\d{4}).* regex for year will get the year from the date and store it in year variable. – user1281921 Apr 22 '12 at 23:45
So you want to match everything besides the month? – Jack Apr 22 '12 at 23:49
Yes, everything besides the month – user1281921 Apr 22 '12 at 23:50

score 0 · Answer 2 · answered Apr 22 '12 at 23:52

0

(?<=\-).*(?=\-) matches the month only.

answered Apr 22 '12 at 23:52

Jack

5,680
10
49
74

Splitting date regex

2 Answers2