PHP: Parse Dates in CSV with inconsistent date formats

Written by

on

in

, ,

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

About the author:

Catzie Avatar

The homo sapiens behind these blog posts is “Catzie“

Explore my top blog posts:

Comments

One response to “PHP: Parse Dates in CSV with inconsistent date formats”

Leave a Reply

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