CSV#

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 ")
);