preg_replace regex question

[sde]

i found a solution to my problem without having to create custom scripts .. but i'm still kinda curious what the preg_replace string would look like.

i have a text file named "sounds.txt"

1 Piano
2 Guitar
3 Organ
4 Steel Drums

The file has over 1000 sounds on it.

i wanted to extract only the sound names into an array, then bring them into a database. i thought the php function preg_replace would do this best, but i couldn't get it to work. here is how i attempted to do it:

PHP Code:

<?
// put each line of the text file into an array
$array=file("sounds.txt");

// strip out first number and space for every line
foreach($array as $each)
{
  $newArray[]=preg_replace("^[0-9]*\s" , " " , $each);
}

// insert sounds in database
foreach($newArray as $each)
{
  $result=mysql_query("insert into table set sound='$each'");
}

?>

now my question is really with the "preg_replace" function. is that regular expression correct for what i'm trying to do?

^[0-9]*\s

the above should match "1 " or "100 " :: note there is a space after the numbers.

[sdeming]

preg_replace is probably overkill for extracting such uniform fields, so I would recommend using something like this:

PHP Code:

$newArray[]=substr(strstr($each, ' '), 1); 


Or using explode:

PHP Code:

$parts = explode(" ", $each);
$newArray[] = $parts[1]; 


[Admin]

wouldnt the explode() command fail when there is a space in the sound name? ie. 'Steel Drums' so it would break it up into

number
word1
word2

and your result would only be 'word1' ... please correct me if i am wrong.....

[sdeming]

Oops, you are right! Disregard the explode method and just use the substr(strstr(...)) one instead.

[sde]

holy smokes batman! strstr() is a beatiful thing =)

thanks