Tyler,

Your script works. But I still have some issues. After I ran my surveys, my output file is as follows:
F

Code:

ork,1,68
Fork,2,72
Fork,3,64

Bike,1,28
Bike,2,24
Bike,3,20

Car,1,44
Car,2,40
Car,3,36

I used this sed command

Code:

sed -e 's/,/./' -e 's/,/=/' filename >> SW1_filename2

to make it look like this

Code:

Fork1=68
Fork2=72
Fork3=64

Bike1=28
Bike2=24
Bike3=20

Car1=44
Car2=40
Car3=36

However it won’t do it. With the commas in the format, your script does not work; with the equal sign, it works. Any idea what I am doing wrong?

---------- Post updated at 11:24 AM ---------- Previous update was at 09:46 AM ----------

Disregard my previous posting. I mistakenly enterer a comma instead of a semicolon. That's why it was not working.

Thanks!

---------- Post updated at 11:31 AM ---------- Previous update was at 11:24 AM ----------


Now, if you could explain the script to me, that would help. I need to modify it somehow. Basically what I am trying to do is to the following:
The output data for all the groups has 6 entries.But while most of the groups has only three entries filled, some groups have all 6 entries filled. What I want to do is Whenever the script reads the file and sees a group with only 3 entries filled, it needs to print the three rows that have data but strip the other three empty rows; for the groups with 6 entries filled, it just needs to print them out. That would be fantastic if you or someone else could help.


Thanks!

---------- Post updated at 07:56 PM ---------- Previous update was at 11:31 AM ----------

Hey rdcwayx,
I tried your script but got this error message.

Code:

awk: record `1.3=12
1.2=348
1.1=180
...' too long

For your info, my input file format was as follows:

Code:

554.3=432
554.2=264
554.1=96
555.3=452
555.2=284
555.1=116
556.3=488
556.2=320
556.1=152
557.3=340
557.2=172
557.1=4
558.3=356
558.2=188
558.1=20
559.3=108
559.2=276
559.1=444

Keep in mind that this represents a fraction of a huge database.

Let me know what you think.

Thanks!