class.ilCSVUtil.php

Go to the documentation of this file.

<?php

class ilCSVUtil
{
    public static function &processCSVRow(
        array &$row,
        bool $quoteAll = false,
        string $separator = ';',
        bool $outUTF8 = false,
        bool $compatibleWithMSExcel = true
    ): array {
        $resultarray = [];
        foreach ($row as $rowindex => $entry) {
            $surround = false;
            if ($quoteAll) {
                $surround = true;
            }
            if (str_contains($entry, '"')) {
                $entry = str_replace('"', '""', $entry);
                $surround = true;
            }
            if (str_contains($entry, $separator)) {
                $surround = true;
            }
            if ($compatibleWithMSExcel) {
                // replace all CR LF with LF (for Excel for Windows compatibility
                $entry = str_replace(chr(13) . chr(10), chr(10), $entry);
            }
            if ($surround) {
                if ($outUTF8) {
                    $resultarray[$rowindex] = '"' . $entry . '"';
                } else {
                    
                    $resultarray[$rowindex] = iconv('UTF-8', 'ISO-8859-1', '"' . $entry . '"');
                }
            } elseif ($outUTF8) {
                $resultarray[$rowindex] = $entry;
            } else {
                $resultarray[$rowindex] = iconv('UTF-8', 'ISO-8859-1', $entry);
            }
        }
        return $resultarray;
    }
}