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.

Catzie

A Filipino who is a mobile & web developer on weekdays, and a baker on weekends. 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. I also like traveling and recording song covers, but I only do so occasionally. Follow on Twitter: @catzie

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 *