Fgetcsv()在将.csv文件转换为数组时不尊重换行符 - fgetcsv() not respecting newlines while converting .csv file to array

fgetcsv() not respecting newlines while converting .csv file to array

我有这个包含机场代码和城市名称的数组(大约3500行)。

code,city
"Abilene, TX ",ABI
"Adak Island, AK ",ADK
"Akiachak, AK ",KKI
"Akiak, AK ",AKI
"Akron/Canton, OH ",CAK
"Akuton, AK ",KQA
"Alakanuk, AK ",AUK
"Alamogordo, NM ",ALM

我需要将该文件转换为php数组。这是我到目前为止的代码:

if(($handle = fopen('test.csv', 'r')) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ',', '"')) !== FALSE) {
        echo '<pre>';
            print_r($data);
            echo '</pre>';
    }
    fclose($handle);
}

虽然我正在为fgetcsv函数设置分隔符和包围符，但我得到的结果是:

Array
(
    [0] => code
    [1] => city
"Abilene
    [2] => TX "
    [3] => ABI
"Adak Island
    [4] => AK "
    [5] => ADK
"Akiachak
    [6] => AK "
    [7] => KKI
"Akiak
    [8] => AK "
    [9] => AKI
"Akron/Canton
    [10] => OH "
    [11] => CAK
"Akuton
    [12] => AK "
    [13] => KQA
"Alakanuk
    [14] => AK "
    [15] => AUK
"Alamogordo
    [16] => NM "
    [17] => ALM
)

如果是换行符，您可以尝试使用暴力方法:

$file = file_get_contents("test.csv");
$data = array_map("str_getcsv", preg_split('/'r*'n+|'r+/', $file));
print_r($data);

str_getcsv在PHP 5.3中可用，或者在手册中通过upgradephp或PHP_Compat作为解决方案。

试试这个:-

ini_set('auto_detect_line_endings', TRUE);/// (PHP's detection of line endings) write at the top.

$csvrows = array_map('str_getcsv', file($filepath));
$csvheader = array_shift($csvrows);
$csv = array();
foreach ($csvrows as $row) {
   $csv[] = array_combine($csvheader, $row);
}

try-

$csv = array();
if (($file = fopen('test.csv', 'r')) === false) {
    throw new Exception('There was an error loading the CSV file.');
} else {  
   while (($line = fgetcsv($file, 1000)) !== false) {
      $csv[] = $line;
   }
   fclose($handle);
}

要解决这个问题，您可以尝试在使用fgetcsv解析之前修剪每行的空白。

if (($handle = fopen('test.csv', 'r')) !== FALSE) {
    while (($line = fgets($handle)) !== FALSE) {
        $line = trim($line); // Trim whitespace from the line
        $data = str_getcsv($line, ',', '"'); // Parse CSV data
        
        echo '<pre>';
        print_r($data);
        echo '</pre>';
    }
    fclose($handle);
}

在更新后的代码中，我们使用fgets读取文件的每行，然后修剪以删除任何开头或结尾的空白。最后，使用str_getcsv对CSV数据进行解析。