Shell Programming and Scripting

I have file where it contains 2 columns. In two columns the first column is repeated more than once. I wanted to take the unique record in first column
and the corresponding second column value .

The below is the example of the file:

8244100320012955|000b063471a4
8244100320012955|00080e5a6624
8244100330007664|0004bde2ac84
8244100330007664|00080e429228
8244100330011369|0004bd0ec236
8244100330011369|0012c9a1c44a
8244100330016046|00080e0b46c4
8244100330016046|000b06cb18fe

In the above example i need the output as
8244100320012955|00080e5a6624
8244100330007664|00080e429228
8244100330011369|0012c9a1c44a
8244100330016046|000b06cb18fe

I am using the following command
cat f1.txt | cut -d"|" -f 1,2 |sort |uniq -d|wc -l

but the above command is failed

Please help me.

Thank you very much in advance.

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

Code:

awk -F\| 'count[$1]++==1' infile

It has solved the problem.
I didn't get the meaning of the below code
count[$1]++==1
if you can explain it will be of great help.
genius
Thank you very much

Yes,
the count is an associative array (or hash, in Perl dialect):

1. Its keys ($1) are unique.
2. It's post incremented.

Consider the following example:

Code:

$ cat file
8244100320012955|000b063471a4
8244100320012955|00080e5a6624
8244100330007664|0004bde2ac84
8244100330007664|00080e429228
8244100330011369|0004bd0ec236
8244100330011369|0012c9a1c44a
8244100330016046|00080e0b46c4
8244100330016046|000b06cb18fe

$ awk -F\| '{ print NR, $0, count[$1]++ }' file
1 8244100320012955|000b063471a4 0
2 8244100320012955|00080e5a6624 1
3 8244100330007664|0004bde2ac84 0
4 8244100330007664|00080e429228 1
5 8244100330011369|0004bd0ec236 0
6 8244100330011369|0012c9a1c44a 1
7 8244100330016046|00080e0b46c4 0
8 8244100330016046|000b06cb18fe 1

You want only the 1's.

Hope this helps.

now i got it.

Thank you very much
for your help