Help split up data

[gotornot]

i have created a shopping cart and i wanted to add a mass add script.
I will use a standard form to post the data over but what comands do i use to take that data and split it up ready for insertion into the database.

I will be copy and pasting from a excel spreadsheet so im assuming its tsv.
Any help would be great.

I am looking at the explode function however how owuld that work in the scenario below:
Block A - Block B - Block C
Bob - Smith - Stinks
Fred - Jones - Clear

Is there any limit to blocks and rows and how do i start to seperate them and check them.

[dagon]

explode first on the line break then the on the hyphen

[BuzzPHP]

dagon is right. Here is example code. Im old school, I like example code.

<?php 
$data = 
"Block A - Block B - Block C
Bob - Smith - Stinks
Fred - Jones - Clear";

echo "<table border=1>";
foreach (explode("\n", $data) as $row)
{
  echo "<tr>";
  foreach (explode("-", $row) as $cell) echo "<td>".trim($cell)."</td>";
  echo "</tr>";
}
echo "</table>";
?>