PHP: Parse Dates in CSV with inconsistent date formats

A friend was having trouble with a CSV file that she needs to process via PHP before saving to database. The CSV files uploaded to the server have inconsistent date formats such as:

So I prepared a PHP script that lists possible date formats in an array $possible_date_formats and then iterates through the dates read from the CSV file, matching each against the date formats in the array.

Assuming you have a .csv file with tab-delimited data such as this:

My PHP file will output this when it’s run:

And below is the PHP file I’m talking about.

Related Posts:

Posts that may be related to "PHP: Parse Dates in CSV with inconsistent date formats":


A Filipino programmer and baker. When I have time to spare, I blog, play video games, watch series (usually anime), cook dishes, draw, or spend a little time with pets. When I have the rare luxury of time, I get to travel and record song covers too! Running small-time online dessert shops Cookies PH and Catzie's Cakery.

One comment on “PHP: Parse Dates in CSV with inconsistent date formats


Leave a Reply

Your email address will not be published. Required fields are marked *