TYPO3 CMS  TYPO3_8-7
TYPO3\CMS\Core\Utility\CsvUtility Class Reference

Static Public Member Functions

static csvToArray ($input, $fieldDelimiter=',', $fieldEnclosure='"', $maximumColumns = 0)
 
static csvValues (array $row, $delim=',', $quote='"')
 

Detailed Description

Class with helper functions for CSV handling

Definition at line 20 of file CsvUtility.php.

Member Function Documentation

◆ csvToArray()

static TYPO3\CMS\Core\Utility\CsvUtility::csvToArray (   $input,
  $fieldDelimiter = ',',
  $fieldEnclosure = '"',
  $maximumColumns = 0 
)
static

Convert a string, formatted as CSV, into an multidimensional array

This cannot be done by str_getcsv, since it's impossible to handle enclosed cells with a line feed in it

Parameters
string$inputThe CSV input
string$fieldDelimiterThe field delimiter
string$fieldEnclosureThe field enclosure
int$maximumColumnsThe maximum amount of columns
Returns
array

Definition at line 33 of file CsvUtility.php.

Referenced by TYPO3\CMS\Frontend\DataProcessing\CommaSeparatedValueProcessor\process().

◆ csvValues()

static TYPO3\CMS\Core\Utility\CsvUtility::csvValues ( array  $row,
  $delim = ',',
  $quote = '"' 
)
static

Takes a row and returns a CSV string of the values with $delim (default is ,) and $quote (default is ") as separator chars.

Parameters
array$rowInput array of values
string$delimDelimited, default is comma
string$quoteQuote-character to wrap around the values.
Returns
string A single line of CSV

Definition at line 79 of file CsvUtility.php.

Referenced by TYPO3\CMS\Core\Database\QueryView\csvValues(), and TYPO3\CMS\Core\Utility\GeneralUtility\csvValues().