ilCSVUtil Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilCSVUtil:

Static Public Member Functions
static &	processCSVRow (array &$row, bool $quoteAll=false, string $separator=';', bool $outUTF8=false, bool $compatibleWithMSExcel=true)
	Convertes an array for CSV usage. More...

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Definition at line 20 of file class.ilCSVUtil.php.

Member Function Documentation

processCSVRow()

static& ilCSVUtil::processCSVRow ( array &  $row, bool  $quoteAll = false, string  $separator = ';', bool  $outUTF8 = false, bool  $compatibleWithMSExcel = true  )

static

Convertes an array for CSV usage.

Processes an array as a CSV row and converts the array values to correct CSV values. The "converted" array is returned

Parameters

array	$row	The array containing the values for a CSV row
bool	$quoteAll	Indicates to quote every value (=TRUE) or only values containing quotes and separators (=FALSE, default)
string	$separator	The value separator in the CSV row (used for quoting) (; = default)

Returns

array The converted array ready for CSV use

Deprecated:

Definition at line 34 of file class.ilCSVUtil.php.

Referenced by ilObjUserFolder\createCSVExport(), and ilObjAssessmentFolderGUI\exportLogObject().

     : 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;
    }

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• Services/CSV/classes/class.ilCSVUtil.php