Problem disecting string

[nickk]

Hi, I have a string in the following format:
"var1","var2","var3","|{cr}"bar1","bar2","bar3","|{cr} ..and so on
Now, I have a script that is meant to split this string into an array, each containing the var, so I can manipulate it and move on.

I have the following, but it doesnt seem to work properly, it works properly for the first "set" of variables (1 set is upto the "|{cr} part, {cr} by the way is a carrige return), and then just keeps printing the first set over and over. I'v looked at my script over and over and can't figure it out. It is included below:

$oldpos = 1;

for($i=0; $i < 2; $i++) 
{
	$pos = strpos($str, '|' . ord(13), $oldpos);
	$length = $pos - $oldpos;
	$fields = substr($str, $oldpos, $length); 
	$oldpos = $pos + 1;

	$field = preg_split('/","/', $fields);

	echo $field[0] . ", ";
	echo $field[1] . ", ";
	echo $field[2] . "<br> ";


}

$str is the string. Can anyone help me with why this doesnt work 🙁

[tsinka]

Hi,

try something like

<?PHP
$str ='
"aaa","bbb","ccc"|
"ddd","eee","fff"|
"ggg","hhh","iii"|
';

preg_match_all('§"(.*?)","(.*?)","(.*?)"\\|§si',$str,$matches);

print_r($matches);
echo "<br>";

if (count($matches)) {
  for ($cnt=0;$cnt<count($matches[1]);$cnt++) {
    $arr = array();
    for ($cnt2=1;$cnt2<count($matches);$cnt2++) {
      $arr[] = $matches[$cnt2][$cnt];
    }
    echo implode(",",$arr);
    echo "<br>\n";
  }
}

?>

Thomas

[LordShryku]

Maybe I'm missing something here, and there's some greater purpose, but why not just do this?

$str  = '"var1","var2","var3","|{cr}"bar1","bar2","bar3","|{cr}';
$find = array('"', ',',  ', |{cr}');
$rep  = array('',  ', ', '<br />');
echo str_replace($find, $rep, $str);

[nickk]

Thanks for the replies. tsinka, that doesnt work very well, as it still has the vriables in "". LordShryku, I need each of them in a seperate variable for easy modification, so the way I do it is easy for me, apart from the fact that it doesnt work 🙁. I'm sure there is some small error that is stopping it from working, jsut xcant find it .

[tsinka]

What do you mean with still has the vriables in "" ?

EDIT: comment out the print_r line (I added it just to check how the array looks like). Post a file containing example data.

Thomas

[nickk]

The result looks something like this:
83382,3,26","Elvira","xxxxx","-","xxx","5","mooi en geil!", etc

While if I do it with my original script it looks like this:
83382, 3, 26, Elvira, xxxxx, -, xxxx, 5, mooi en geil!,

EDIT: Not sure if you guys knew this, but there are more than 3 variables per "group", more like 16

[tsinka]

Ok,

next try:

<?PHP
$str ='"aaa","bbb","ccc","123","456"|
"ddd","eee","fff","tttt","dfads"|
"ggg","hhh","iii"|
';

$arr = explode("|",$str);

foreach($arr as $value) {
  $value = trim($value,"\" \r\n");
  if (!empty($value)) {
    $data = preg_split('§","§',$value);
    echo implode(",",$data)."<br>\n";
  }
}
?>

EDIT: $data contains the values. You can use e.g.

$data[] = preg_split(....);

to create a multi dimensional array holding the data (predefine $data as empty array outside the foreach loop).

EDIT 2: $data = explode('","',$value); instead of $data = preg_split('§","§',$value); should work, too.

Thomas