Off the top of my head I would use: $f = fopen("filename.csv","r"); $data = fread($f,filesize("filename.csv")); fclose($f);
$split = explode("\n",$data); $counter = 0; foreach($split AS $row) { $myarray = explode(",",$row); $myarray[2] = md5($myarray[2]); $split[$counter] = implode(",",$myarray); $counter++; } $save = implode("\n",$split); $f = fopen("outfile.csv","w"); fwrite($f,$save); fclose($f); Don't quote me on that though since thats just off the top of my head. Adam Voigt [EMAIL PROTECTED] On Wed, 2002-10-09 at 08:39, Verdon Vaillancourt wrote: > Hi, > > I hope this question isn't too basic... > > I have a flat file (CSV) that I want to import into a mySQL db via > phpMyAdmin. The file has about 1200 rows and is in a format like: > "value","value","password","value","value","etc" > The passwords are in clear text. I need them to be encrypted in md5. > > Is there any advice out there as to how I could process this flat-file > before I import into my db or after the fact? > > Thanks, verdon > Ps. Please cc me if replying to list as I am on digest mode > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php