Shell Programming and Scripting

Here is my dilemma.

I have a file that looks something like this

name: Type1 group: Group1
name: Type1 group: Group2
name: Type1 group: Group3
name: Type2 group: Group3
name: Type2 group: Group2
name: Type2 group: Group4
name: Type3 group: Group5
name: Type3 group: Group2
name: Type3 group: Group1
name: Type3 group: Group4

Now I need a loop to create another file that would look like this

data_2_1_1 = new Option("Group1","Group1");
data_2_1_2 = new Option("Group2","Group2");
data_2_1_3 = new Option("Group3","Group3");
data_2_2_1 = new Option("Group3","Group3");
data_2_2_2 = new Option("Group2","Group2");
data_2_2_3 = new Option("Group4","Group4");
data_2_3_1 = new Option("Group5","Group5");
data_2_3_2 = new Option("Group2","Group2");
data_2_3_3 = new Option("Group1","Group1");
data_2_3_4 = new Option("Group4","Group4");

Notice how the second and third digit increments
The second will increment when the type changes and the third one will
increment with as many GROUPS that the TYPE belongs to.

Thanks for all the help!

Forgot to mention that this is an example only and the actual name: and group: are different

Use nawk or /usr/xpg4/bin/awk on Solaris.

Code:

awk '{
printf "data_2_%d_%d = new Option(\"%s\",\"%s\");\n",
!__[$2]++?++c:c, ++_[$2], $NF, $NF
}' file

Nice stuff thanks a million

One more question to finish this off if I would want to
have the same file however with

data_2_1 = new Option("Type1","Type1");
data_2_2 = new Option("Type2","Type2");


and so on .....

Thanks again

Like this?

Code:

awk '!_[$2]++{
printf "data_2_%d = new Option(\"%s\",\"%s\");\n", ++c, $2, $2
}' file

Your good thanks ... ! Exactly what I needed!
Will keep these handy!