Trying to separate dates into three columns.

I need to prep data to be scored. I think the decision tree will work better with day month and year broken into speperate columns. I got the first data set split using RegX. The second one is more tricky because some months are two digits and others are one. The sections are seperated by by backslash, but I am pretty new at this and am not sure how to seperate the date using that. Any advice would be great, Thank you.

Regex

Parse

Date Time

Join

Preparation

Expression

Accepted answers

MarqueeCrew

How about:

(\d+).(\d+).(\d+)

All comments

MarqueeCrew

How about:

(\d+).(\d+).(\d+)

Riot

Thank you for the amazingly fast and amazingly accurate answer.

ScottTexas

I Marquee, I need to do the same thing, Take a date formated as month year-month-date (xxxx-xx-xx) and split each component into three different columns, year, month and date. But i don't understand your answer, where does this formula (\d+).(\d+).(\d+) go?

thanks,
Scott

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167