[Resolved] explode by column?

[skeetley]

Hi all,
I am reading http://www.weatheroffice.ec.gc.ca/data/conditions/yestcond.met into an array. Problem is I explode by a space and because the city names vary in the number of words, it screws it up for when I want to get the numbers on the right side of the city names. Any suggestions? Maybe explode is not the way to go? Thanks.

[tekky]

I would say you have either have to (if that was exported data) add a delimiter to the export option... or...

regexp it... and for the match on city and max temp...
for city do something like a-z(maybe 1 space but not more && more a-z){0,} (maybe -)0-9.0-9

im not a regexp person... but I would think its posssible to repeat the match for maybe 1 space and a-z as many times as you like....

maybe Weedpacket will chime in here 🙂

[skeetley]

Thanks tekky. I hope someone like Weedpacket can help me here. I don't even need the city names if there is some way to even ignore the chars and just take the ints.

[tekky]

I think I Can help with that... 😃

if (eregi("([a-z]{3})[ *]([0-9]{4}/[0-9]{2}/[0-9]{2} [0-9]{2}:[0-9]{2}) [^0-9 *]([0-9\-\.]{3,}) ([0-9\-\.]{3,}) ([0-9\.]{3,}) ([0-9\-:]{4,6}) ([0-9\-:]{4,6}) ([0-9\-:]{4,6}) ([0-9\-:]{4,6})", $variable, $matches))
{
   echo 'MAtched!<br><pre>';
   print_r($matches);
   echo '</pre>';
}
else
{
    echo 'No match :(<br>';
}

not tested... may work.... $matched would contain the values if it works 😛

[khaine]

If the position of the values stays constant why not just cut up each line with the substr() command?