CODEWITHSUNDEEP
php
Bence
Bence

Reputation: 97

Getting first and third word from string if tenth is a specific word

I have a constantly updated URL .txt file and I would like to grab the first and third words from every line where the tenth word is "B738". The words are spearated with ':'

Example from the file, here is 1 line: (yes, it is 1 line)

RYR98G:1374442:First Last:PILOT::36.50552:-13.87929:31183:451:B738:438:LPFR:31000:LPMA:UK1:100:1:7010:::1:I:0:0:1:41:3:30:GCXO:+VFPS+/V/PBN/A1B1C1D1S1S2 DOF/190521 REG/EIEFF OPR/RYR PER/C RMK/TCAS:N0438F310 IXOL9V IXOLI DCT LATRU DCT VERAM Q205 PECKY UQ146 EPAKA EPAK1X:0:0:0:0:::20190521084125:215:30.121:1020:

I would like to grab the "RYR98G" and the "First Last" because the tenth word is B738

<?php


$text = file_get_contents('http://data.vattastic.com/vatsim-data.txt');
$lines = explode("\n", $text);
$skipped_content = implode("\n", array_slice($lines, 62));

echo nl2br($skipped_content);


?>

Upvotes: 0

Views: 33

Answers (3)

Nick
Nick

Reputation: 147246

Something like this should do what you want:

foreach ($lines as $line) {
    $words = explode(':', $line);
    if (isset($words[9]) && $words[9] == 'B738') {
        echo "First: $words[0]\nThird: $words[2]\n";
    }
}

Output (for your sample line):

First: RYR98G
Third: First Last

Demo on 3v4l.org

Upvotes: 3

Mariano
Mariano

Reputation: 455

Here the stript, you need to load the content of your txt, in a variable. 

<?php 
$input_lines = "RYR98G:1374442:First Last:PILOT::36.50552:-13.87929:31183:451:B738:438:LPFR:31000:LPMA:UK1:100:1:7010:::1:I:0:0:1:41:3:30:GCXO:+VFPS+/V/PBN/A1B1C1D1S1S2 DOF/190521 REG/EIEFF OPR/RYR PER/C RMK/TCAS:N0438F310 IXOL9V IXOLI DCT LATRU DCT VERAM Q205 PECKY UQ146 EPAKA EPAK1X:0:0:0:0:::20190521084125:215:30.121:1020:"; // example of line

$matches = array(); //Array 
$search = preg_match_all('/(.*?):(.*?)/im', $input_lines, $matches); //regex matching

if($matches[1][9] == "B738") //target :)
{
  print_r('B738 Found! <br />');
  print_r('Item 1!'.$matches[1][0].'<br />');
  print_r('Item 2!'.$matches[1][3].'<br />');
}

// Debug of your array. As you can see all items matched.
foreach ($matches[1] as $match) {
  echo " Item: ".$i."<br />";
    echo $match;
  $i++;

}

Upvotes: 0

Jayson Garcia
Jayson Garcia

Reputation: 190

<?php
$text = file_get_contents('http://data.vattastic.com/vatsim-data.txt');
$lines = explode(":", $text);
if( $lines[9] == "B738" ){
    echo $lines[0]; //RYR98G
    echo $lines[2]; //First Last
}
?>

Upvotes: 0

Related Questions