A simple lesson in Arrays? 2

[madasafish]

I am reading a XML file and can capture poid, poname and huid parameters easily but am struggling to catch the fourth parameter "suid" because it matches on "huid" at another random line in the file.

I have simplified the issue with the data shown below. The "...." in the example shown below are random number of lines.

poid=12		poname=fred 	huid=42
......
huid=51		suid=274
...
poid=09		poname=harry 	huid=84
....
huid=42		suid=189
......
huid=84		suid=2009
..
poid=27		poname=bert 	huid=51

I want to get this output.

12	fred 	42	189
09	harry 	84  	2009
27	bert 	51	274

As always, thanks in advance

Madasafish

 

[PHV]

Madasafish, just to know, did you try my last suggestions ?