Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Script to count number of rows Post 302879699 by ssk250 on Saturday 14th of December 2013 03:10:52 AM
Old 12-14-2013
Script to count number of rows

Hi,

I need a solaris shell script to read multiple files and count number of unique name rows(strings) from those files. The input and output should be like this
Input:
file 1
Code:
abc                          
cde                          
abc                          
abc

file 2
Code:
xyz
kds
abc
cde

file 3
Code:
xyz
abc
cde
abc


Output:
In the input total no of strings are 12 but abc is repeated 6 times,cde is repeated 3 times and xyz is repeated 2 times and kds once. As per my requirement though the total count is 12 it should show count as 4(i.e unique strings) only

i.e , output is Count = 4

Can any help me please............

Thanks in advance>>

Last edited by Scrutinizer; 12-14-2013 at 04:18 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows??

Hi friends I have 100 files in my directory. Each file look like this.. Temp1 Temp2 Temp3 MAS 1 2 3 MAS 4 5 6 MAS 7 8 9 Delhi 10 11 12 Delhi 13 14 15 Delhi 16 17 ... (4 Replies)
Discussion started by: ks_reddy
4 Replies

2. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows?

Hi Friends, In continuation to my earlier post https://www.unix.com/shell-programming-scripting/99166-script-find-average-given-column-also-specified-number-rows.html I am extending my problem as follows. Input: Column1 Column2 MAS 1 MAS 4 ... (2 Replies)
Discussion started by: ks_reddy
2 Replies

3. UNIX for Dummies Questions & Answers

how to count number of rows and sum of column using awk

Hi All, I have the following input which i want to process using AWK. Rows,NC,amount 1,1202,0.192387 2,1201,0.111111 3,1201,0.123456 i want the following output count of rows = 3 ,sum of amount = 0.426954 Many thanks (2 Replies)
Discussion started by: pistachio
2 Replies

4. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ... (6 Replies)
Discussion started by: juelillo
6 Replies

5. UNIX for Dummies Questions & Answers

count number of rows based on other column values

Could anybody help with this? I have input below ..... david,39 david,39 emelie,40 clarissa,22 bob,42 bob,42 tim,32 bob,39 david,38 emelie,47 what i want to do is count how many names there are with different ages, so output would be like this .... david,2 emelie,2 clarissa,1... (3 Replies)
Discussion started by: itsme999
3 Replies

6. Shell Programming and Scripting

Shell script to count unique rows in a CSV

HI All, I have a CSV file of 30 columns separated by ,. I want to get a count of all unique rows written to a flat file. The CSV file is around 5000 rows The first column is a time stamp and I need to exclude while counting unique Thanks, Ravi (4 Replies)
Discussion started by: Nani369
4 Replies

7. Shell Programming and Scripting

Script to count number of files in directories

Hi All! I would like to have a script that will count the number of files at the top of the hour of soome directories and mail the results to me. I was thinking on : a=`/directory/subdirectory/ | wc -l` echo "/directory/subdirectory :$a" b=`/another_dir/subdir/ | wc -l` echo... (12 Replies)
Discussion started by: fretagi
12 Replies

8. Shell Programming and Scripting

Extract and count number of Duplicate rows

Hi All, I need to extract duplicate rows from a file and write these bad records into another file. And need to have a count of these bad records. i have a command awk ' {s++} END { for(i in s) { if(s>1) { print i } } }' ${TMP_DUPE_RECS}>>${TMP_BAD_DATA_DUPE_RECS}... (5 Replies)
Discussion started by: Arun Mishra
5 Replies

9. Shell Programming and Scripting

Reseting row count every given number of rows

I have a file with 48 rows. I am counting 6 rows and adding 6 to that number and repeating the operation, and then output the value in column 1. For the second column, I would like to get sort of a binary output (1s and 2s) every 3rd row. This is what I have: awk '{print ++src +... (1 Reply)
Discussion started by: Xterra
1 Replies

10. UNIX for Beginners Questions & Answers

What script would I use to count the number of a term and its opposite?

Hello All, I am looking to write a script to count the number of a term and its opposite and create a new file with said list. I can get the terms to print to the file but only one or the other and not both. I tried this: grep -wi done */all.txt | grep -wiv done */all.txt > "filename" ... (5 Replies)
Discussion started by: mcesmcsc
5 Replies
named.star(4)						     Kernel Interfaces Manual						     named.star(4)

NAME
named.star - Defines data used by named to initialize the BIND (Berkeley Internet Name Domain) name server file SYNOPSIS
/etc/namedb/named.* DESCRIPTION
The data files referenced in the named.conf file can have any names, but they are generally given names of the form /etc/namedb/named.*. This naming convention is used for convenience in maintaining the named daemon's file. The records in the named data files are called resource records. Except for comments (starting with a ; (semicolon) and continuing to the end of the line), the resource records in the data files generally follow the format of the resource records that the named daemon returns in response to queries from resolver routines. The named.conf file is the default configuration (or boot) file for the named server. The named daemon reads the start-up file when the named daemon starts and when receiving the signal SIGHUP. EXAMPLES
The following examples portray two domains on two different networks: Domain abc.aus.osf.com, Internet address 192.9.201.n (where n varies for each system on the network) Domain xyz.aus.osf.com, Internet address 128.114.100.n (where n varies for each system on the network) In this sample configuration, both the primary and the secondary name servers are in the abc.aus.osf.com domain, and host hera is the gateway host. The following are sample entries in a named.ca file: ; root name servers. 1 IN NS relay.osf.com. relay.osf.com. 3600000 IN A 129.114.1.2 The following two files are sam- ple entries from the named.data files for hosts venus and allen. (The data files can have any name you choose, as long as that name is defined in the named.boot file. In this case, the names are named.abcdata and named.xyzdata.) The named file for host venus is in the following file, called named.abcdata: ;OWNER TTL CLASS TYPE RDATA ;local domain server is venus @ IN SOA venus bob.robert.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum IN NS venus IN NS kronos IN MX 10 venus.abc.aus.osf.com. ; address for local loopback localhost IN A 127.1 ; address of machines in the same domain venus IN A 192.9.201.1 venus IN A 128.114.100.1 venus IN MX 10 venus.abc.aus.osf.com. veabc IN CNAME venus IN WKS 192.9.201.1 udp (tftp nameserver domain) IN WKS 192.9.201.1 tcp (echo telnet smtp discard uucp-path systat daytime netstat chargen ftp time whois finger hostnames domain) ; delimiter for WKS kronos IN A 192.9.201.2 krabc IN CNAME kronos hera IN A 192.9.201.5 IN A 128.114.100.5 robert IN A 192.9.201.6 ernie IN A 192.9.201.7 IN HINFO HP-800 OS1 robert.abc.aus.osf.com. IN MX 10 venus.abc.aus.osf.com. The named file for host allen is in the following file, called named.xyzdata: ;OWNER TTL CLASS TYPE RDATA ;local domain server is venus xyz.aus.osf.com. IN SOA venus.abc.aus.osf.com. bob.robe rt.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum xyz.aus.osf.com. IN NS venus.abc.aus.osf.com. IN NS kronos.abc.aus.osf.com. IN MX 10 venus.abc.aus.osf.com. ; address for local loopback localhost IN A 127.1 ; address of machines in the same domain allen IN A 128.114.100.3 allen IN MX 10 venus.abc.aus.osf.com. alxyz IN CNAME allen IN WKS 128.114.100.3 udp (tftp nameserver domain) IN WKS 128.114.100.3 tcp (echo telnet smtp discard uucp-path systat daytime netstat chargen ftp time whois finger hostnames domain) ; delimiter for WKS fred IN A 128.114.100.10 mike IN A 128.114.100.11 IN HINFO HP-800 OS1 The following is a sample named.local file that might appear on hosts in either of the sample domains: @ IN SOA venus.abc.aus.osf.com. gail.zeus.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum IN NS venus.abc.aus.osf.com. 1 IN PTR localhost. The following two files are sample entries from the named.rev files for hosts venus and allen. For this example, the files are called named.abcrev and named.xyzrev. The reverse file for host venus is in the following file, called named.abcrev: @ IN SOA venus.abc.aus.osf.com. bob.robert.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum 9.201.192.in-addr.arpa. IN NS venus.abc.aus.osf.com. IN NS kronos.abc.aus.osf.com. IN PTR hera.abc.aus.osf.com. ;ABC.AUS.OSF.COM Hosts 1.201.9.192.in-addr.arpa. IN PTR venus.abc.aus.osf.com. 2.201.9.192.in-addr.arpa. IN PTR kronos.abc.aus.osf.com. 5.201.9.192.in-addr.arpa. IN PTR hera.abc.aus.osf.com. 6.201.9.192.in-addr.arpa. IN PTR robert.abc.aus.osf.com. 7.201.9.192.in-addr.arpa. IN PTR ernie.abc.aus.osf.com. The reverse file for host allen is in the following file, called named.xyzrev: @ IN SOA venus.abc.aus.osf.com. bob.robert.abc.aus.osf.com. ( 1.1 ;serial 3600 ;refresh 600 ;retry 3600000 ;expire 86400) ;minimum 100.114.128.in-addr.arpa. IN NS venus.abc.aus.osf.com. IN NS kronos.abc.aus.osf.com. IN PTR hera.abc.aus.osf.com. ;XYZ.AUS.OSF.COM Hosts 3.100.114.128.in-addr.arpa. IN PTR allen.abc.aus.osf.com. 10.100.114.128.in-addr.arpa. IN PTR fred.abc.aus.osf.com. 11.100.114.128.in-addr.arpa. IN PTR mike.abc.aus.osf.com. ;ABC.AUS.OSF.COM Hosts 1.100.114.128.in-addr.arpa. IN PTR venus.abc.aus.osf.com. 5.100.114.128.in- addr.arpa. IN PTR hera.abc.aus.osf.com. RELATED INFORMATION
Daemon: named(8). delim off named.star(4)
All times are GMT -4. The time now is 09:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy