Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

to retrieve unique values

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting to retrieve unique values
# 1  
Old 02-05-2007
to retrieve unique values
Hi all,
I have a 10.txt file. In this file 2 words are present by name Active and Inactive and these words are repeated 7000 times. I want to take the unique 2 words from this 7000 lines.

Thanks
Mahalakshmi.A
# 2  
Old 02-05-2007
Although your question is not clear, a sample input/output would help. But I'll assume that you want extract unique names from the first column of your input file:
Code:
sort -k 1,1 -u inputfile

Above will give you the last occurrence of names.
# 3  
Old 02-05-2007
It's working fine. I would like to know about the -u -k optiosn in the sort command. Could you please explain.

thanks
# 4  
Old 02-05-2007
Quote:
Originally Posted by mahalakshmi
It's working fine. I would like to know about the -u -k optiosn in the sort command. Could you please explain.

thanks
-k 1,1 sort the content of inputfile using first column as the primary sort key and -u is there to display uniq values only. Read the man sort for more details.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Code to get unique values

Hello All, I am trying to write a script which returns me clientID,programId,userID indicated in bold from the below log files.Log file is having many such data , iam just presenting sample . Sample Log file. hostname 1525867288264 UA:MP:EP491418 http-nio-8080-exec-11 ERROR Get Price... (13 Replies)
Discussion started by: nextStep
13 Replies

2. Shell Programming and Scripting

How to retrieve values from XML file and update them in the same position! PLEASE HELP?

Good Day All Im quiet new to ksh scripting and need a bit of your help. I am attempting to write a script that reads in an XML and extracts certain field values from an XML file. The values are all alphanumeric and consist of two components: e.g "Test 1". I need to to create a script that... (2 Replies)
Discussion started by: JulioAmerica
2 Replies

3. Programming

Sctp api name to retrieve the values of structure sctpassoctable

Hi i want a sctp (lksctp) api which can retrieve the values of the sctp structure "sctpAssocTable" It is sctpassoctable or sctpassocentry. SctpAssocEntry ::= SEQUENCE { sctpAssocId Unsigned32, sctpAssocRemHostName OCTET STRING, sctpAssocLocalPort ... (1 Reply)
Discussion started by: harioum
1 Replies

4. Shell Programming and Scripting

Retrieve values using soap moudle

Can someone tell me how to know the values used in soap api. I need to know what values are used in soap xml. Can we get all the values used in soap api. I know that we can get it by using SOAP::Lite module in perl. But it is like we are supplying keys and we are getting values. I want... (0 Replies)
Discussion started by: Anjan1
0 Replies

5. Shell Programming and Scripting

Retrieve multiple values for each iteration

Hi All, I tried to retrieve multiple values using for/foreach loop in each iteration. But couldn't get it. Please help me. Below are my try outs: #!/bin/ksh foreach {i,j,k} {5150 5540 5149 5640 5151 5920 5362 5965 5147 5895 5061} echo $i,$j,$k end Error: ./mulcns.ksh: foreach: not... (4 Replies)
Discussion started by: cns1710
4 Replies

6. Shell Programming and Scripting

how to retrieve lines that the first 4 columns have different values

Hi, all: I am not familiar with unix,and just started awk scripts. I want to retrieve lines that have the first 4 columns with different values. For example, the input is like this (tab delimited file with one header) r1 A A A A x r2 A B B A x r3 B B B B x the output should be (header is... (15 Replies)
Discussion started by: new2awkin2011
15 Replies

7. UNIX for Dummies Questions & Answers

need to retrieve values of parameter

Hi, I am just new to this shell scripting wizard..i have a text file which contains content as below: Parameter=10; What should be the script which only fetches the value 10 not the Parameter. The idea is to get the logic behind getting the value alone not its parameter,.... (6 Replies)
Discussion started by: d8011
6 Replies

8. Shell Programming and Scripting

have to retrieve the distinct values (not duplicate) from 2nd column and display

I have a text file names test2 with 3 columns as below . We have to retrieve the distinct values (not duplicate) from 2nd column and display. I have used the below command but giving some error. NS3303 NS CRAFT LTD NS3303 NS CHIRON VACCINES LTD NS3303 NS ALLIED MEDICARE LTD NS3303 NS... (16 Replies)
Discussion started by: shirdi
16 Replies

9. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

10. Shell Programming and Scripting

Getting Unique values in a file

Hi, I have a file like this: Some_String_Here 123 123 123 321 321 321 3432 3221 557 886 321 321 I would like to find only the unique values in the files and get the following output: Some_String_Here 123 321 3432 3221 557 886 I am trying to get this done using awk. Can someone please... (5 Replies)
Discussion started by: Legend986
5 Replies
Login or Register to Ask a Question