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!
---------
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)
Thanks,
cool@xxxxxxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
