Shell Programming and Scripting

Hi there,

If I have the following:

and want to print the first column based on the uniqe value of the second column, so the output would be something like:

how would I do that, using AWK and the piping technique?

Thanks in advance

Hi

Code:

awk '!a[$2]++{print $1}' file

Guru

thanks for the help guru,

unfortunely, it hasn't worked well.. as I got values in column $1 more than what $2 has

thanks for the help any way,, I really value that

---------- Post updated at 08:29 PM ---------- Previous update was at 06:42 PM ----------

I think I didn't explain that properly

what I meant is printing the first column while sorted by the second one on which "uniq" is applied

any help is highly valued

Can you provide us the contents inputfile (unless it is the same as before), the script you are using, and the contents of the outputfile?

Thanks for your interest sir,

the input file is an access log file that keeps hold of IPs, files access, and the the transmission protocol, and so on..

If I want an output that contains the protocol and the file accessed using that protocol

given that protocol column is sorted using "uniq" command.

and that the file column is sorted by the protocol column.

so if I have something like:
it should look like this:


I hope that does made it clearer?

thank you again

But HTTP \img\333.jpg does not appear in the output?

yep, only the first changing value in the protocol is printed in addition to the file value on the same line.