File manipulation?
 

Dear All
From my previous posts, I learned on how to modify my text file to filter out undesired ones. I need to know how to find the number of occurances of distinct records in my text file. Please find attached my text file. Can you please show me the power of my Linux on file manipulation issues? Actually, I want to find the number of occurances of distinct CallId in my logfile.

From what I understood !!

This will count number of uniquer CallIs

@ grail

This will not give you the unique count, as I understood OP want count of unique Callids

I am getting two different results from the following two codes :
#awk '{print $2}' logfile4 | sort -u | wc -l
#cut -d " " -f2 logfile4 | sort -u | wc -l
In your opinion , which one is correct?

What is the difference ?

The correct answer is the one with awk
ie. ~~>"awk '{print $2}' logfile4 | sort -u | wc -l"<~~

The manner in which cut is used above fails for the below given lines where the second field starts after "two" blank spaces after the first field ends; whereas awk simply ignores the consecutive blank spaces while separating the columns.

CallId 400 State TK bt 2 bt 0 Tr (2 0x0d) E (3 0 1) Tr (0 0 2)
CallId 3 State TK bt 7 bt 2 Tr (13 0x0f) E (4 1 11) Tr (0 2 0)
CallId 3 State TK bt 7 bt 2 Tr (13 0x0f) E (4 1 11) Tr (0 2 0)
CallId 3 State TK bt 7 bt 2 Tr (13 0x0f) E (4 1 11) Tr (0 2 0)

The awk one. awk treats any number of spaces as a word separator. Cut takes a single space as a field delimiter so awk always gets the CallID value and sometimes cut gets a space. Here's an illustration

Oops...
The extra space is not visible in the post, although it is present.
Just vi the file and go to line number 1393 and u will be able to see that.

Thank you very much. So I will base my calculations on the result of 'awk' output.

Thanks PMP, missed that bit :( This should do:

I'm confused about what the OP wants.