CSV Import from Excel

[trob]

http://www.fabrikar.com/forums/index.php?threads/csv-import-problem-sign-diamond-with-question-mark-at-end-of-data.39532/#post-198651
importcsv.php (line 1448) is doing

if ($this->inPutFormat == 'excel' || $this->inPutFormat == 'fabrikexcel')
{
    $encFrom = $this->inPutFormat == 'fabrikexcel' ? 'UTF-16LE' : 'Windows-1252';

    foreach ($arr_row as $k => $v)
    {
        $arr_row[$k] = trim($arr_row[$k]);

        if ($arr_row[$k] !== '')
        {
            $arr_row[$k] = iconv($encFrom, 'UTF-8', $arr_row[$k] . "\0");
            $arr_row[$k] = str_replace('""', '"', $arr_row[$k]);
            $arr_row[$k] = preg_replace("/^\"(.*)\"$/sim", "$1", $arr_row[$k]);
        }
    }
}

If I delete . "\0" it's ok. Why is it there? Is it necessary for UTF-16LE?

[cheesegrits]

I have a feeling that may just be because it looks like we copied the code from an example on the PHP manual page for fgetcsv page:

http://php.net/manual/en/function.fgetcsv.php#101295

... which was actually using UCS2 encoding. I don't think either UTF-16LE or Windows-1252 use null terminated lines, they should both use either \r\n or \n.

I'd suggest we just try removing it and see what happens. :)