PHP provides the fgetcsv function to automatically import values from a csv file. However it does not consistently work with cases where the starting of a field value has an extended character like the pound sign or a foreign character. In such cases, fgetcsv simply omits that first character and gets the remaining data of the column.<\/p>\n
Eg.”Buyagift.co.uk”,”273″,”xmas1075″,”\u00a310 off when you spend over \u00a375 on all products excluding our amazing special offers”<\/strong><\/p>\n will be imported as<\/p>\n “Buyagift.co.uk”,”273″,”xmas1075″,”10 off when you spend over \u00a375 on all products excluding our amazing special offers”<\/strong><\/p>\n One officially recommended way of handling this is to set the locale before running fgetcsv . But somehow this does not always work. After trying various approaches we have come up with our own solution which works in all cases.<\/p>\n We do our own preprocessing of the csv file before passing it to fgetcsv(). Our approach is to detect any character following a comma which is beyond the ascii printable range of codes from 32 to 126. If it detects any such character it precedes it with a slash. The complete\u00a0 data thus updated is written back to the file and then passed to fgetcsv().<\/p>\n So “Buyagift.co.uk”,”273″,”xmas1075″,”\u00a310 off when you spend over \u00a375 on all products excluding our amazing special offers”<\/strong><\/p>\n will become “Buyagift.co.uk”,”273″,”xmas1075″,”\u00a310 off when you spend over \u00a375 on all products excluding our amazing special offers”<\/strong><\/p>\n At a later stage the once the data array has been obtained from fgetcsv, we remove the preceding slash by running stripcslashes() to the value.<\/strong><\/p>\n The code fragment is given below:<\/p>\n } \/\/ rewrite processed data back to file Handling The Euro Symbol \u20ac<\/span><\/span><\/strong><\/p>\n The above approach does not work for the Euro symbol since it does not get correctly interpreted even if a file is open in utf-8 mode. For this, the solution to open the file and simply replace the euro symbol with its html entity equiv: & html ; (remove the spaces in between).<\/span><\/span><\/p>\n Eg. $data = str_replace(“\u0080”,”€”,$data);<\/strong>
\nif ($f) {
\n$data = fread($f, filesize(“myfile.csv”));
\nfclose($f);
\n$arr = explode(“n”, $data);
\n$newData = “”;
\nfor($i = 0; $i < count($arr); $i++) {
\n$item = $arr[$i];
\nif (strlen($item) > 2) {
\n$x = explode(“,”,$item);
\nfor($j = 0; $j < count($x); $j++)
\n{
\nif (ord($x[$j]) > 126)
\n{
\n$x[$j] = “\\”.$x[$j];
\n}
\n}
\n$arr[$i] = implode(“,”,$x);
\n$item = $arr[$i];
\n$newData .= $item . “rn”;
\n}<\/p>\n
\n}<\/p>\n
\n$f = fopen(“myfile.csv”, “w”);
\nif ($f) {
\nfwrite($f, $newData);
\nfclose($f);
\n}
\nelse
\necho(“Unable to create file:”);<\/p><\/div>\n
\n<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"