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.
"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