dongyuli0964 2017-02-21 17:47
浏览 93
已采纳

迭代CSV文件并获取指定标题的每个值?

I have a CSV file and I want to check if the row contains a special title. Only if my row contains a special title it should be converted to XML, other stuff added and so on.

My question now is, how can I iterate through the whole CSV file and get for every title the value in this field?

Because if it matches my special title I just want to convert the specified row where the title is matching my title. Maybe also an idea how I can do that?

Sample: CSV File

I must add that feature to my actual function. Because my actual function is just is converting the whole CSV to XML. But I just want to convert the specified rows.

My actual function:

function csvToXML($inputFilename, $outputFilename, $delimiter = ',')
{
  // Open csv to read
  $inputFile = fopen($inputFilename, 'rt');

  // Get the headers of the file
  $headers = fgetcsv($inputFile, 0, $delimiter);

  // Create a new dom document with pretty formatting
  $doc = new DOMDocument('1.0', 'utf-8');
  $doc->preserveWhiteSpace = false;
  $doc->formatOutput = true;

  // Add a root node to the document
  $root = $doc->createElement('products');
  $root = $doc->appendChild($root);

  // Loop through each row creating a <row> node with the correct data
  while (($row = fgetcsv($inputFile, 0, $delimiter)) !== false) {
    $container = $doc->createElement('product');
    foreach ($headers as $i => $header) {
      $child = $doc->createElement($header);
      $child = $container->appendChild($child);
      $value = $doc->createTextNode($row[$i]);
      $value = $child->appendChild($value);
    }

    $root->appendChild($container);
  }

  $strxml = $doc->saveXML();
  $handle = fopen($outputFilename, 'w');
  fwrite($handle, $strxml);
  fclose($handle);
}
  • 写回答

1条回答 默认 最新

  • dongliyu3278 2017-02-21 18:03
    关注

    Just check the title before adding the rows to XML. You could do it by adding the following lines:

     while (($row = fgetcsv($inputFile, 0, $delimiter)) !== false) {
    
        $specialTitles = Array('Title 1', 'Title 2', 'Title 3'); // titles you want to keep
    
        if(in_array($row[1], $specialTitles)){
            $container = $doc->createElement('product');
            foreach ($headers as $i => $header) {
              $child = $doc->createElement($header);
              $child = $container->appendChild($child);
              $value = $doc->createTextNode($row[$i]);
              $value = $child->appendChild($value);
            }
    
            $root->appendChild($container);
        }
      }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图的问题
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名