X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FHelper%2FCsv.pm;h=5b629ee63b6f9dd181baba6cc475c1aa5f837895;hb=297ec9f0dcfb45a3d695506c824f13fd72f7d312;hp=3132b284699a3e4b756bc9386dad1a48e65ee784;hpb=72b340de2352eec7d3f99a00e2141a2df35f07f3;p=kivitendo-erp.git diff --git a/SL/Helper/Csv.pm b/SL/Helper/Csv.pm index 3132b2846..5b629ee63 100644 --- a/SL/Helper/Csv.pm +++ b/SL/Helper/Csv.pm @@ -111,6 +111,14 @@ sub _check_header { ]) unless $header; } + # Special case: utf8 BOM. + # certain software (namely MS Office and notepad.exe insist on prefixing + # data with a discouraged but valid byte order mark + # if not removed, the first header field will not be recognized + if ($header && $header->[0] && $self->encoding =~ /utf-?8/i) { + $header->[0] =~ s/^\x{FEFF}//; + } + return unless $header; return $self->header([ map { lc } @$header ]); }