Extracting data from text/string

[computer guy]

Hi everyone,

 

 

Is there a way that I can extract the following

 

etaRadio Ratings Dump – Current at 26/03/09<--The date

DJ Joelstar                          14 12 14 15 18 21 16 20.17<--These eight numbers (seperate) and the DJ name

 

 

From a string like this

etaRadio Ratings Dump – Current at 26/03/09
DJ Joelstar                           14 12 14 15 18 21 16 20.17
DJ Ant                                   0 0 0 0 0 0 0 0.00
DJ Jaxon                               18 16 14 19 21 14 17 21.89
DJ Chuckmeister85          19 21 24 32 24 18 23 29.61
DJ Pat4life                           21 20 24 28 21 18 22 28.33
DJ JessieB                            0 0 0 0 0 0 0 0.00

 

Thank you 

[corbin]

explode

 

 

 

By the way, the description of the PHPF Questions, Comments, Suggestions section:

 

This is NOT a help forum!

Discussions about our website should go here. Feature requests, compliments, complaints... whatever you want, just be nice

[computer guy]

Thank you

 

Sorry I couldn't find where 2 ask a help related question.

[Daniel0]

Uh... perhaps in "PHP Help", which is like 5 cm below this forum unless you have a gigantic monitor. How difficult is it to just look over all the boards? It'll take two minutes tops.

[computer guy]

I have a 15" monitor so I dont think that is the problem. Im sorry but I didn't see "PHP help". Thank you for moving the thread.

[POG1]

Where is the date? :S Is this supposed to be the date?

19 21 24 32 24 18 23 29.61

[computer guy]

etaRadio Ratings Dump – Current at 26/03/09<--The date

That is the date.

 

Thank you

[sasa]

try

<?php
$test = 'etaRadio Ratings Dump – Current at 26/03/09
DJ Joelstar                           14 12 14 15 18 21 16 20.17
DJ Ant                                   0 0 0 0 0 0 0 0.00
DJ Jaxon                               18 16 14 19 21 14 17 21.89
DJ Chuckmeister85          19 21 24 32 24 18 23 29.61
DJ Pat4life                           21 20 24 28 21 18 22 28.33
DJ JessieB                            0 0 0 0 0 0 0 0.00';

preg_match('/Current at\s(\d+\/\d+\/\d+)/',$test,$date);
echo $date[1],"<hr />\n";
preg_match_all('/(.*)\s+(([0-9]+ ){7}[0-9\.]+)/',$test,$numbers);
$dj = $numbers[1];
foreach ($dj as $k => $v) $dj[$k] = trim($v);
$num = $numbers[2];
foreach ($num as $k => $v) $num[$k] = explode(' ',trim($v));
$data = array_combine($dj, $num);
echo '<pre>',print_r ($data),'</pre>';
?>

[computer guy]

Thank you sasa