Pase Text File

mist3r0

Hello boys, I've a problem, I've this text document,

== Discografia ==
{{vedi anche|Discografia dei Coldplay}}

=== Album registrati in studio ===
* [[2000]] - ''[[Parachutes]]''
* [[2002]] - ''[[A Rush of Blood to the Head]]''
* [[2005]] - ''[[X&Y]]''
* [[2008]] - ''[[Viva la Vida or Death and All His Friends]]''

=== Album registrati dal vivo ===
* [[2003]] - ''[[Live 2003]]''
* [[2009]] - ''[[LeftRightLeftRightLeft]]''

now I want to get only the date and the title of the albums, but I don't know how to do!!

Can you help me?? 😕😕

NogDog

One way:

<?php
$data = array();
$fh = fopen('test.txt', 'r') or die('could not open file');
while(($line = fgets($fh, 999)) !== false)
{
   if(strpos($line, '*') === 0) // must use ===
   {
      preg_match_all('/(?<=\[\[).*?(?=\]\])/', $line, $matches);
      if(count($matches == 2))
      {
         $data[] = array('date' => $matches[0][0], 'title' => $matches[0][1]);
      }
   }
}
echo "<pre>".print_r($data,1)."</pre>";

mist3r0

NogDog thanks for the great help, I'm testing the code tomorrow and sent you the result!!

Now I go to sleep, thanks very much again 😉

mist3r0

Hello NogDog,

Your script It's ok, but when i run it the output is:

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Array
(
[0] => Array
(
[date] => 2000
[title] => Parachutes
)
.
.
.
The output conitue and it is ok,........but why he says there is a error on line 11??

You can modify you script for to take this type of strings, too?

* [[1998]] - ''Safety EP''

mist3r0

mist3r0;10940117 wrote:
Hello NogDog,

Your script It's ok, but when i run it the output is:

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Array
(
[0] => Array
(
[date] => 2000
[title] => Parachutes
)
.
.
.
The output conitue and it is ok,........but why he says there is a error on line 11??

You can modify you script for to take this type of strings, too?

* [[1998]] - ''Safety EP''

sorry, I've forget to ask you if in the chenges of the script you can insert that this string is recognized, too

*''[[Familiar to Millions]]'' (2000)

mist3r0

mist3r0;10940117 wrote:
Hello NogDog,

Your script It's ok, but when i run it the output is:

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Notice: Undefined offset: 1 in C:\Program Files\EasyPHP5.3.0\www\Prog RIW\parserOK.php on line 11

Array
(
[0] => Array
(
[date] => 2000
[title] => Parachutes
)
.
.
.
The output conitue and it is ok,........but why he says there is a error on line 11??

You can modify you script for to take this type of strings, too?

[[1998]] - ''Safety EP''

Sorry!! I've forget to ask you, if in the script changes you can insert the possibility of recognizing
this string ''[[Familiar to Millions]]'' (2000) and the string * [[1998]] - ''Safety EP''

mist3r0

I apologize for the repeated messages, it wasn't my intention to do this! :quiet:

I apologize to everyone!

NogDog

I had a typo on this line:

if(count($matches == 2))

It should be:

if(count($matches) == 2)

That should probably take care of the undefined offset error and side-effects.

mist3r0

Thank NogDog, but if I modifie the code with:

if(count($matches) == 2)

It don't work! this is my output

Array
(
)

It's possible that the error is caused because in my file there are this string:

*''[[Familiar to Millions]]'' (2000)

[[1998]] - ''Safety EP''[/COLOR]

and It not recognize them?

Can you modifie the script for ricognize this file? (It is same as before, but with this two string in more)

== Discografia ==
{{vedi anche|Discografia dei Coldplay}}

=== Album registrati in studio ===
* [[2000]] - ''[[Parachutes]]''
* [[2002]] - ''[[A Rush of Blood to the Head]]''
* [[2005]] - ''[[X&Y]]''
* [[2008]] - ''[[Viva la Vida or Death and All His Friends]]''

=== Album registrati dal vivo ===
* [[2003]] - ''[[Live 2003]]''
* [[2009]] - ''[[LeftRightLeftRightLeft]]''
[COLOR="Red"]*''[[Familiar to Millions]]'' (2000)
* [[1998]] - ''Safety EP''[/COLOR]

NogDog

<?php
$text = file_get_contents('path/to/file.txt');
$date = '(?:\[\[|\()(\d{4})(?:\]\]|\))';
$title = '\'\'(?:\[\[)?(.*?)(?:\]\])?\'\'';
$regex = "/^\*\s*?($date.*?$title|$title.*?$date)\s*?\$/m";
preg_match_all($regex, $text, $matches, PREG_SET_ORDER);
$data = array();
foreach($matches as $match)
{
   if(!empty($match[4]) && !empty($match[5]))
   {
      $data[] = array('title' => $match[4], 'date' => $match[5]);
   }
   elseif(!empty($match[2]) && !empty($match[3]))
   {
      $data[] = array('title' => $match[3], 'date' => $match[2]);
   }
}
?>
<pre><?php print_r($data); ?></pre>

mist3r0

Yahooooooooooo!!! Now It WORK!!!

thanks very much NogDog!! 😉

The error was the strings that it not recognized.

mist3r0

Hello NogDog, sorry, I've a last request for you...

I've another file with this strings:

|align="center"|[[1969]]
|align="center"|'''''[[Ferdinand II]]'''''
|align="center"|1
|align="center"|1
|align="center"|12x text
|-
|align="left" valign="top"|[[2003]]
|align="left" valign="top"|''[[Gocce (album)| First]]''
|align="center" valign="top"|-
|align="center" valign="top"|-
|align="center" valign="top"|35,000

I tired to parse it with the last parser that you have made, but it don't work.

Can you make a last parser for this file for take the date and the title??...please, I'll my last request!! :o