UNIX for Dummies Questions & Answers

Greetings.

I am a UNIX newbies.

I am currently facing difficulties dealing with a large data set and I would like to ask for helps. I have a input file like this:

ak 1 AAM1
ak 2 AAM1
ak 3 AAM1
ak 11 AMM2
ak 12 AMM2
ak 13 AMM2
ak 14 AMM2

Is there any possibility for me to have an output like:
SET1
ak 1 AAM1
ak 2 AAM1
ak 3 AAM1
END
SET2
ak 11 AMM2
ak 12 AMM2
ak 13 AMM2
ak 14 AMM2
END
...

It is too complicated for me and I do not know which language to use too. Please give me your opinion. Thank you very much.

Amanda

try out this..

Code:

for i in `cat <file_name>| awk '{print $3}' | sort | uniq`; do echo "SET";  echo $i | sed -e "s/^.*\(.\)$/\1/"; grep $i testing;echo "END";done

<file_name> -- original file

---------- Post updated at 07:04 AM ---------- Previous update was at 06:59 AM ----------

Try this one

Code:

for i in `cat testing | awk '{print $3}' | sort | uniq`; do a="SET"; b=`echo $i | sed -e "s/^.*\(.\)$/\1/"`;echo $a$b; grep $i testing;echo "END";done

Thank you. It is very helpful!

However, probably I was not careful for giving the input and output file format, I am sorry. If I would like to have the SET in continuous number, such as SET1, SET2, SET3, and so on, which is not following the last letter of the second string, would that be possible?

Thank you once again for your reply.

please provide a better example of what is your input and output. I guess kamaraj has given the best solution to what you asked.

Yes, the code is very helpful, however when I applied the code to the large dataset, the output file is like below:

SETG
ak 126 A1BG
ak 893 A1BG
END
SETF
ak 109 A1CF
ak 127 A1CF
ak 169 A1CF
END
SET1
ak 101 A2BP1
ak 106 A2BP1
ak 103 A2BP1
ak 107 A2BP1
...

Hence, I was just wonder whether the SET on top on each word set can be in continuous manner such as:
SET1
ak 126 A1BG
ak 893 A1BG
END
SET2
ak 109 A1CF
ak 127 A1CF
ak 169 A1CF
END
SET3
ak 101 A2BP1
ak 106 A2BP1
ak 103 A2BP1
ak 107 A2BP1
...

I will be more careful in giving the example next time. Thank you once again.

b=0;for i in `cat testing | awk '{print $3}' | sort | uniq`; do a="SET"; b=`expr $b + 1` ;echo $a$b; grep $i testing;echo "END";done

The code is working. Thank you very much for both of your effort. Excellent!

Thanks again.