c...@hosting4days.com wrote:

On Oct 1, 2009, at 5:02 PM, Ben Dunlap wrote:

You could tackle this in a couple of different ways. Either split your
string into an array first:

$line = fgets($handle);
$columns = explode(",", trim($line));

Thanks Ben - the explode() command worked great!

Use the tool that PHP provides for such problems.



Now a bit of another problem

I'm exporting from another database (mac) to a csv file then a quick import to excel 2004 (mac) for some cleaning...

before the excel import, some date fields look like "2009-9-29 11:21:37" = good for sql import

but excel does an auto reformat to

9/29/2009  11:21:37 AM = not good for sql import

Q: any way to turn this auto reformat off in excel and keep it the way I had it? (I saw nothing in pref's)

try using strtotime() on that field and see if it works.


I'm pretty sure that function will handle it.


Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to