从文本文件中提取块，他们的第一行以同一字符串开始

Question

我有一个动态的文本文件，它的内容可能具有固定的行（重复一次）和X重复块。 “ s21.g00.30.001” ，但是它们不可能相同的内容，这是内容的摘录：

S10.G00.00.001,'www.mywebsite.com' //fixed line
S10.G00.00.002,'Company name' // fixed line
S10.G00.00.003,'v2.01' //fixed line
S10.G00.00.005,'02' //fixed line
.............

S21.G00.30.001,'employee one' //block 1
S21.G00.30.002,'AAAA'
S21.G00.30.004,'BBBB' 
S21.G00.30.005,'02'
S21.G00.30.006,'16021993'
S21.G00.30.007,'4'
S21.G00.30.008,'A Renasca' 
S21.G00 whatever code here ,'some text' // 30 or 40 or 55 ...
S21.G00.30.001,'employee 2' //block 2, S21.G00.30.001 is the divider
S21.G00.30.002,'CCCC'
S21.G00.30.004,'DDDD' 
S21.G00.30.005,'02'
S21.G00 whatever code here ,'some text' // 30 or 40 or 55 ...
S21.G00.30.001,'employee 3' //block 3, S21.G00.30.001 is the divider
S21.G00.30.002,'EEEE'
S21.G00.30.004,'FFFF' 
S21.G00.30.005,'02'
S21.G00.30.007,'4'
S21.G00.30.008,'some text 3'
S21.G00 whatever code here ,'some text' // 30 or 40 or 55 ...

每个块都以相同的代码行开始， 线值仅重复 ，我使用此方法：

$file = fopen($this->getParameter('dsn_txt_folder') . 'dsn.txt', 'r');

    if ($file) {
        while (($line = fgets($file)) !== false) {
            if (str_starts_with($line, 'S10.G00.00.001')) {
                $website = $this->getStringBetween($line, "'", "'");
            }
            if (str_starts_with($line, 'S10.G00.00.002')) {
                $companyName = $this->getStringBetween($line, "'", "'");
            }
            if (str_starts_with($line, 'S10.G00.00.003')) {
                $version = $this->getStringBetween($line, "'", "'");
            }
            .......
       }
            
       fclose($file);

    }

但是对于x重复块，我如何提取以 divider 线开始的每个块 “ s21.g00.30.001” ，但是每个块的末端未知，然后将每个块放入数组中，这样我就可以轻松地读取每行的值。

每个块之间的分隔线或分离器是“ s21.g00.30.001”。

finaly，对于这3个块，我想获得这样的数组。

array:1 [▼
  0 => array:3 [▼
    1 => array:7 [▼
      0 => "S21.G00.30.001,'employee one'"
      1 => "S21.G00.30.002,'AAAA'"
      2 => "S21.G00.30.004,'BBBB'"
      3 => "S21.G00.30.005,'02'"
      4 => "S21.G00.30.006,'16021993'"
      5 => "S21.G00.30.007,'4'"
      6 => "S21.G00.30.008,'A Renasca'"
      7 => "S21.G00.40.008,'some text'"
      8 => "whatever code here,'some text'"
    ]
    2 => array:5 [▼
      0 => "S21.G00.30.001,'employee 2'"
      1 => "S21.G00.30.002,'CCCC'"
      2 => "S21.G00.30.004,'DDDD'"
      3 => "S21.G00.30.005,'02'"
      4 => "S21.G00.30.006,'16021993'"
      5 => "whatever code here,'some text'"
    ]
    3 => array:6 [▼
      0 => "S21.G00.30.001,'employee 3'"
      1 => "S21.G00.30.002,'EEEE'"
      2 => "S21.G00.30.004,'FFFF'"
      3 => "S21.G00.30.005,'02'"
      4 => "S21.G00.30.007,'4'"
      5 => "S21.G00.30.008,'some text 3'"
      6 => "whatever code here,'some text'"
    ]
  ]
]

Answer 1

就个人而言，我首先会使用 file> file_get_get_contents （） 。然后使用 preg_match_all（） a>提取我需要的东西。您可以将此解决方案调整以使用fopen（），fgets（）和preg_match（）自行。

良好的正则表达式将准确捕获您的需求，然后根据您的逻辑来组织数据。这是一个可以处理多个“ ID”字符串的示例：

<?php

//$data = file_get_contents($this->getParameter('dsn_txt_folder') . 'dsn.txt');
$data = "
S10.G00.00.001,'www.mywebsite.com' //fixed line
S10.G00.00.002,'Company name' // fixed line
S10.G00.00.003,'v2.01' //fixed line
S10.G00.00.005,'02' //fixed line
.............

S21.G00.30.001,'employee one' //block 1
S21.G00.30.002,'AAAA'
S21.G00.30.004,'BBBB' sx
S21.G00.30.005,'02'
S21.G00.30.006,'16021993'
S21.G00.30.007,'4'
S21.G00.30.008,'A Renasca'
S21.G00.30.001,'employee 2' //block 2
S21.G00.30.002,'CCCC'
S21.G00.30.004,'DDDD' 
S21.G00.30.005,'02'
S21.G00.30.001,'employee 3' //block 3
S21.G00.30.002,'EEEE'
S21.G00.30.004,'FFFF' 
S21.G00.30.005,'02'
S21.G00.30.007,'4'
S21.G00.30.008,'some text 3'
";
$extracted = [];
$ids = [
    'S21.G00.30.',
    //'S10.G00.00.',
];
foreach($ids as $id){
  $regex = "/^".implode('\\.', explode('.', $id))."(\d{3}),'(.*)'/m"; // "/^S21\.G00\.30\.(\d{3}),'(.*)'/m"
  $matches = [];
  $block = 0;
  preg_match_all($regex, $data, $matches);
  foreach($matches[0] as $i => $full){
    if('001' === $matches[1][$i]) 
      ++$block;
    $extracted[$id][$block][$matches[1][$i]] = $matches[2][$i];
  }
}

var_export($extracted);

这将产生以下内容：

array (
  'S21.G00.30.' => 
  array (
    1 => 
    array (
      '001' => 'employee one',
      '002' => 'AAAA',
      '004' => 'BBBB',
      '005' => '02',
      '006' => '16021993',
      '007' => '4',
      '008' => 'A Renasca',
    ),
    2 => 
    array (
      '001' => 'employee 2',
      '002' => 'CCCC',
      '004' => 'DDDD',
      '005' => '02',
    ),
    3 => 
    array (
      '001' => 'employee 3',
      '002' => 'EEEE',
      '004' => 'FFFF',
      '005' => '02',
      '007' => '4',
      '008' => 'some text 3',
    ),
  ),
)

在此处查看行动： https ：//onlinephp.io/c/fc256

Answer 2

您可以按行解析文件。您将将当前块作为数组变量，将其填充，因为排除行，当新块启动时，只需将上一个块添加到最终结果阵列中。

以下代码使用基本函数（而不是$ this-＆gt;调用，就像您在问题中一样）。您可以根据需要更新代码。

<?php
// the file was placed on my server for testing
$file = fopen('test.txt','r');
// this will contain the final result
$result = [];
// currentBlock is null at first
$currentBlock = null;
while (($line = fgets($file)) !== false) {
    // extracting the line code
    $lineCode = substr($line, 0, 14);
    // checking if the row contains a value, between two '
    $rowComponents = explode("'", $line);
    if (count($rowComponents) < 2) {
        // the row is not formatted ok
        continue;
    }
    $value = $rowComponents[1];
    switch ($lineCode) {
        case 'S10.G00.00.001':
            $website = $value;
            break;
        case 'S10.G00.00.002':
            $companyName = $value;
            break;
        case 'S10.G00.00.003':
            $version = $value;
            break;
        case 'S21.G00.30.001':
            // starting a new entry
            if ($currentBlock !== null) {
                // we already have a block being parsed
                // so we added it to the final result
                $result[] = $currentBlock;
            }
            // starting the current block as an empty array
            $currentBlock = [];
            $currentBlock['property1'] = $value;
            break;
        case 'S21.G00.30.002':
            $currentBlock ['property2'] = $value;
            break;
        case 'S21.G00.30.004':
            $currentBlock ['property4'] = $value;
            break;
    }
}
// adding the last entry into the final result
// only if the block exists
if ($currentBlock !== null) {
    $result[] = $currentBlock;
}
fclose($file);
// output the result for debugging
// you also have the $website, $companyName, $version parameters populated
var_dump($result);

?>

滚动运行后，我从var_dump调用：

array(3) {
  [0]=>
  array(3) {
    ["property1"]=>
    string(12) "employee one"
    ["property2"]=>
    string(4) "AAAA"
    ["property4"]=>
    string(4) "BBBB"
  }
  [1]=>
  array(3) {
    ["property1"]=>
    string(10) "employee 2"
    ["property2"]=>
    string(4) "CCCC"
    ["property4"]=>
    string(4) "DDDD"
  }
  [2]=>
  array(3) {
    ["property1"]=>
    string(10) "employee 3"
    ["property2"]=>
    string(4) "EEEE"
    ["property4"]=>
    string(4) "FFFF"
  }
}