Famous Awk One-Liners Explained, Part III: Selective Printing and Deleting of Certain Lines

You're viewing a comment by Nik and its responses.

Nik Permalink
December 31, 2009, 00:57

Nice site.

I'm stumped with this. I have a file containing
2 AAA
3 AAA
4 AAA
9 AAA
8 XXX
9 XXX
10 XXX
19 XXX
5 BBB
6 BBB
7 BBB
12 BBB
3 FFF
4 FFF
5 FFF
11 FFF

Can I use awk to return an output like
2|9|AAA
8|10|XXX
5|7|BBB
3|4|5|FFF

That is, to return the FIRST and SECOND-TO-THE-LAST numbers for each unique pattern.

Reply to this comment

Reply To This Comment

(why do I need your e-mail?)

(Your twitter name, if you have one. (I'm @pkrumins, btw.))

Comment Help

Type first 3 letters of your name: (just to make sure you're a human)

Please preview the comment before submitting to make sure it's OK.