Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Starting my week off with another challenge, I'm planning on just chugging through them all in order to learn something new from each one, still very much a newbie !
First, im use text to column tool to obtain the 3 fields, using a ',' delimiter. Then, im cleasing the punctuations in all fields, this isnt a problem with the date field because datetime tool is possible to custom a date format (ddMon.yy in this excercise); finally only select the fields. Good luck!!!