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.
Solved! Go to Solution.
Thank you for the amazingly fast and amazingly accurate answer.
A lucky guess ;)
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