note 101295 added to function.fgetcsv

Parse from Microsoft Excel "Unicode Text (*.txt)" format: <?php function parse($file) { if (($handle = fopen($file, "r")) === FALSE) return; while (($cols = fgetcsv($handle, 1000, "\t")) !== FALSE) { foreach( $cols as $key => $val ) { $cols[$key] = trim( $cols[$key] ); $cols[$key] = iconv('UCS-2', 'UTF-8', $cols[$key]."\0") ; $cols[$key] = str_replace('""', '"', $cols[$key]); $cols[$key] = preg_replace("/^\"(.*)\"$/sim", "$1", $cols[$key]); } echo print_r($cols, 1); } } ?> ---- Server IP: 193.219.81.76 Probable Submitter: 213.197.188.36 ---- Manual Page -- http://www.php.net/manual/en/function.fgetcsv.php Edit -- https://master.php.net/note/edit/101295 Del: integrated -- https://master.php.net/note/delete/101295/integrated Del: useless -- https://master.php.net/note/delete/101295/useless Del: bad code -- https://master.php.net/note/delete/101295/bad+code Del: spam -- https://master.php.net/note/delete/101295/spam Del: non-english -- https://master.php.net/note/delete/101295/non-english Del: in docs -- https://master.php.net/note/delete/101295/in+docs Del: other reasons-- https://master.php.net/note/delete/101295 Reject -- https://master.php.net/note/reject/101295 Search -- https://master.php.net/manage/user-notes.php