drk49438 2018-11-13 01:41
浏览 12
已采纳

PHP读取文本文件忽略特定选项卡

I have log file data(.txt) here

As you can see on log file that has Date and Time content.

And now I have PHP function to get the data from log file.

$fromDateTime = new DateTime('Wed, Sep 19  2018 08:00:00');
$toDateTime = new DateTime('Wed, Sep 19  2018 19:59:00');
$file = file_get_contents('Reject.txt');
$lines = explode("
", $file);

// counter
$rowsintimespan = 0;
// keys should correspond to columns
$keys = [
    'Date',
    'Time',
    'Battery level',
    'Piezo sound level',
    'Left (Channel 3) light intensity',
    'Right (Channel 1) light intensity'
];

$values = array_fill(0, count($keys), 0);
$values = array_combine($keys, $values);

// Do Line-By-Line starting by Line 16 (Array Index 15)
for ($i = 11; $i < count($lines); $i++) {
    // if the file is "Tue, Sep 18<tab>2018<tab>23:59:53<tab>"
    $dateobj = DateTime::createFromFormat("???,?M?d??Y?H:i:s+", $lines[$i]);

    // check if date is in your Timespan
    if ($dateobj < $toDateTime && $dateobj > $fromDateTime) {
        $rowsintimespan++; // count if in timespan

        // get line elements
        $lineContent = explode("\t", $lines[$i]);

        // loop through line elements and count them
        $x = 0;
        for ($j = 0; $j < count($keys); $j++) {
            if (!isset($lineContent[$j])) {
                continue;
            }

            // remember position of last not empty column
            if (trim($lineContent[$j]) != '') {
                $x = $j;
            }
        }

        if ($x > 0) {
            $values[$keys[$x]]++;
        }
    }
}

// Debug-Output
echo $rowsintimespan;

// Output every column
echo '<pre>';
print_r($values);

And now I don't want Date and Time including on counting. So I try to remove both, but the result of count is not in the correct keys.

My question, is it possible to ignore both keys then the counting is keep correct?

enter image description here

Above image, I try to removed Date and Time.
The correct one should be, Battery level = 2 and Piezo sound level = 2.

  • 写回答

1条回答 默认 最新

  • dream_high1026 2018-11-13 02:50
    关注

    You should subtract the number of columns: $values[$keys[$x]]++;$values[$keys[$x - 2]]++;

    Here is an updated code snippet:

    <?php
    $fromDateTime = new DateTime('Tue, Nov 13  2018 08:00:00');
    $toDateTime = new DateTime('Tue, Nov 13  2018 19:59:00');
    $file = file_get_contents('reject_new.txt');
    $lines = explode("
    ", $file);
    
    const IGNORE_COLS = 2;  // +++ Introduced const for number of columns to skip
    
    // counter
    $rowsintimespan = 0;
    // keys should correspond to columns
    $keys = [
        // 'Date',         // +++ 
        // 'Time',         // +++ 
        'Battery level',
        'Piezo sound level',
        'Left (Channel 3) light intensity',
        'Right (Channel 1) light intensity'
    ];
    
    $values = array_fill(0, count($keys), 0);
    $values = array_combine($keys, $values);
    
    // Do Line-By-Line starting by Line 12 (Array Index 11)
    for ($i = 11; $i < count($lines); $i++) {
        // if the file is "Tue, Sep 18  2018<tab>23:59:53<tab>"
        $dateobj = DateTime::createFromFormat("???,?M?d??Y?H:i:s+", $lines[$i]);
    
        // check if date is in your Timespan
        if ($dateobj < $toDateTime && $dateobj > $fromDateTime) {
            $rowsintimespan++; // count if in timespan
    
            // get line elements
            $lineContent = explode("\t", $lines[$i]);
    
            // loop through line elements and count them
            for ($j = IGNORE_COLS; $j < count($keys); $j++) {
                if (!isset($lineContent[$j])) {
                    continue;
                }
    
                if (trim($lineContent[$j]) != '') {
                    $values[$keys[$j - IGNORE_COLS]]++;   // −−− Remove redundant $x var
                }
            }
        }
    }
    
    // Debug-Output
    echo $rowsintimespan . PHP_EOL;
    
    // Output every column
    echo '<pre>' . PHP_EOL;
    print_r($values);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿