Help correctly displaying data using explode()

[medar]

I have the following file that I read into a $data variable:

O
H	eid		asof
D	46219808	1126102961
H	product	amt	when		first
D	1031105	1	1123521907	0
D	1031121	0	1123562608	0
D	1190304	0	1124003930	0
D	1190507	1	1123601712	0
D	1220118	0	1123177941	0
D	1220122	0	1123730002	0
D	1220803	0	1123606733	0
D	1222016	1	1124055801	0
D	2051902	13	1125957650	1122006719
D	2051907	4	1125549166	1124677810
$	657	$

There can be any number of the DATA lines (D)...this example has 10, but I have some with 25+ coming out.

Basically line #2 is an employee ID and date variable, and lines 4-13 are product ID, amount, date, and again a date. What I am trying to do is echo this out for display, but without writing a bunch of explodes in there...I am lost.

Here is what I have:

$lines = explode("\n", $data);
$val2 = explode("\t", $lines[2]);

$val4 = explode("\t", $lines[4]);

echo "$val2[1], $val4[1], $val4[2], $val4[3], $val4[4]";

Any suggestions on how I would echo out EACH line of Product data and list the Employee ID at the front of each line? The above example does one line - but I have anywhere from a few lines to 20 or so, and I cannot get this working correctly.

Thanks for any help or suggestions.

[medar]

OK, made a bit of progress...but ran into another issue now that I have solved one.

Using:

$lines = explode("\n", $data);
$num = count($lines);
$val2 = explode("\t", $lines[2]);

foreach ($lines as $v) {
   $exp = explode("\t", $v);
   echo "Values: $val2[1], $exp[1], $exp[2], $exp[3], $exp[4].<br />\n";
}

This is exploding exactly what I need...except I need to disregard some of the information. I am now extracting:

Values: 46219808, , , , .
Values: 46219808, eid, asof, , .
Values: 46219808, 46219808, 1126113901, , .
Values: 46219808, product, amt, when, first.
Values: 46219808, 1031105, 1, 1123521907, 0.

.....repeats for each line and ends with:

Values: 46219808, 657, $, , .
Values: 46219808, , , , .

So its almost there. What I now need to do is totally disregard the first 4 lines listed above (and start with my product information)....and also disregard the last two lines.

Anyone have any quick thoughts on this one?

[medar]

IF statement for the win.

Got it working.

[dalecosp]

Yay! Now mark it [RESOLVED] so we don't waste any further page loads on it? 😉