text to table`

[Anon]

I am trying to split this text into a table

row1col1
row1col2
row1col3

row2col1
row2col2
row2col3

row3col1
row3col2
row3col3

basically this is - a row is seperated by a double newline and each col is seperated by a newline character. I try to use explode("\n\n",string) or split("[\n\n]",string)

but these seem to produce 1 row and 12 cols
any one any idears. how i can split this without using a normal character as a delimiter. any help what so ever

[techek]

I assume your source is a textfile or something and that is what this example is made on :

<?php
// put data into an array
$data = file('<your_file>');

// row 1 is the first row
$row = 1;
$col = 1;
// run through all elements in array
while(list($index, $value) = each($data)) {

// if element contains nothing else than a newline, a new row is located
if ($value == "\n") {

  // col 1 is the first column
  $col = 1;

  // advance to the next row
  $row++;
  echo "<br>\nRow.nr. $row<br>\n";
} else { // another columns is found, show it!
  echo "Col.nr. $col contains '$value'<br>\n";
  // advance to the next (possible) coloumn
  $col++;
} 

}

?>

The whole idea is to check each line to see if it contains a newline-char, if it is, begin a new row, else show the content of it and advance to the next element.

PS : If it doesn't help you at all, feel free to contact me, k'?

[mrskhris]

There can be a simpler reason.
If you read this data from textarea, all lines will be separated not only by "\n", but also wit "\r", so full form will be "\r\n". Try this combination.