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've received a csv file where the date filed contains multiple different date formats: dd/mm/yyyy, dd/mm/yy, dd-mm-yyyy, ddmmyyyy. Also silly errors like dd/mm/yyy.
I've resolved most of the errors but I'm looking for a way to fix the rest handful of rows where the date is either:
dd/mm/yyy (digit missing from the year)
Can anybody recommend a nice way to find and fix these fields?
You will need to be cautious of situations like 9-Jun-20 though because if you ran that today it would use 2020 and it isn't clear how you decide which one to use when the year is not provided.
@jdunkerley75 If it's not too much could you please explain what the meaning of [/\-] is in the formula?
@kimikoxavier That's just telling which punctuation to remove from the data, so it will remove / or \ or - if it's in the date.
Got it. Thanks so much!