I hv a data file like this...

id1 id2 number amount
abc 111 35 25.00
abc 111 24 55.00
abc 222 35 65.00
abc 222 58 68.00
def 333 69 58.00
def 333 68 98.00
def 444 88 58.00
def 555 68 68.00

i want the output like this...

name : abc name2 : 111
---------------------------
35 25.00
24 55.00
---------------------------
name2 : 222
---------------------------
35 65.00
58 68.00
---------------------------
name : def name2 : 333
---------------------------
69 58.00
68 98.00
---------------------------
name2 : 444
---------------------------
88 58.00
---------------------------
name2 : 555
---------------------------
68 68.00
---------------------------

i could use while loop for upto id1 but unable to create an inner loop to break id2

Kindly help me...

Hi,

Sounds like homework to me!

Show us what you have tried to date.

some lines from coding...
{
while($1!=prev){
print""
printf"Name:%s\n",$1
prev=$1
}
print $0
}

like above

with this i could break whenever the value of first field changes
but i dont know how to break whenever the value of the second field
changes...

and one more problem in the above code is that... it is not writing the
very first value of the first field.... i mean to say that the value abc
is not appearing...but the next def and so on can be seen. where I am going
wrong.. Kindly help me.

hey i got the solution.....!!!

I replaced the while condition by while ($1!=prev1 || $2!=prev2)...it worked well...

say cheers to me...!!!