This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am not certain this solution matches the required answer, but I think I my interpretation of the question is correct. Please do let me know if it isn't
Pretty good challenge!
My solution attached. Got a 5 record variance-- would love to see the workflow that originally created the solution file!
Got a 100% match using RegEx - a few curveballs in the cleaning, but I see that as adding to the challenge!
My solution. Like in some people versions, there are differences in results. However, the idea of the workflow looks correct.
Pretty much regex did most of a job with extracting year :). I think it's slick enough.
I also had trouble matching the output exactly, but this is very close.
close enough for the time spent on it