NAME
Kernel::System::CSV – CSV lib
DESCRIPTION
All csv functions.
PUBLIC INTERFACE
new()
Don't use the constructor directly, use the ObjectManager instead:
my $CSVObject = $Kernel::OM->Get('Kernel::System::CSV');
Array2CSV()
Returns a csv formatted string based on a array with head data.
$CSV = $CSVObject->Array2CSV(
WithHeader => [ 'RowA', 'RowB', ], # optional
Head => [ 'RowA', 'RowB', ], # optional
Data => [
[ 1, 4 ],
[ 7, 3 ],
[ 1, 9 ],
[ 34, 4 ],
],
Separator => ';', # optional separator (default is ;)
Quote => '"', # optional quote (default is ")
Format => 'CSV', # optional format [Excel|CSV ] (default is CSV)
);
CSV2Array()
Returns an array with parsed csv data.
my $RefArray = $CSVObject->CSV2Array(
String => $CSVString,
Separator => ';', # optional separator (default is ;)
Quote => '"', # optional quote (default is ")
);