ilCSVUtil Class Reference

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

Definition at line 18 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 32 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 (strpos($entry, "\"") !== false) {
                $entry = str_replace("\"", "\"\"", $entry);
                $surround = true;
            }
            if (strpos($entry, $separator) !== false) {
                $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] = utf8_decode("\"" . $entry . "\"");
                }
            } else {
                if ($outUTF8) {
                    $resultarray[$rowindex] = $entry;
                } else {
                    $resultarray[$rowindex] = utf8_decode($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