Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Counting non-specific occurrences within a file.
Top Forums Shell Programming and Scripting Counting non-specific occurrences within a file. Post 302732685 by funkynmr on Monday 19th of November 2012 03:05:56 AM
Old 11-19-2012
Counting non-specific occurrences within a file.
I'm pretty new to scripting and didn't see an example of this issue yet. I am trying to count and print the total number of times each value is found within a file. Here is a short example of my starting file.

Code:
value	3
value	3
value	3
value	3
value	4
value	6
value	6
value	6
value	6
value	8
value	8
value	8

The entire file I am working with is very large and I will not be able to know each value in advance. I'm trying to get to a file that looks like this

Code:
value	3	4
value	4	1
value	6	4
value	8	3
...	....	...

with column 3 being the total number of times a specific value (i.e value 3) is found within the file.

I've tried a couple different grep and wc commands but these seem to be fore specific searches. Any help would be appreciated.

Thanks
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Counting occurences of specific charachter in a file

Hi, I need to count the number of occurences of the character " in a file that contains huge number of records. What command could I use? Please specify in detail since I am new :| Thanks much. (3 Replies)
Discussion started by: GMMike
3 Replies

2. Shell Programming and Scripting

Counting the differences based on a specific rule

Hi, I've been trying to create a perl file to run something very specific. But I'm not getting any success. I'm not very good with hashing. I have a file with two columns (tab separated) (already sorted) 99890 + 100281 + 104919 - 109672 + 113428 - 114501 + 115357 + 115598 ... (7 Replies)
Discussion started by: labrazil
7 Replies

3. Shell Programming and Scripting

counting number of pattern occurrences

Hi All, Is it possible to count number of occurrences of a pattern in a single record using awk?? for example: a line like this: abrsjdfhafa I want to count the number of a character occurrences. but still use the default RS, I don't want to set RS to single character. (1 Reply)
Discussion started by: ghoda2_10
1 Replies

4. Shell Programming and Scripting

Counting specific words from the log

Hi, I need a shell script which can provide details from error logs like this Aug 23 21:19:41 red mountd: authenticated mount request from bl0110.bang.m pc.local:651 for /disk1/jobs (/disk1) Aug 23 08:49:52 red dhcpd: DHCPDISCOVER from 00:25:90:2b:cd:7c via eth0: unknown client Aug 24... (2 Replies)
Discussion started by: ratheeshp
2 Replies

5. Shell Programming and Scripting

Counting occurrences of all words in multiple files

Hey Unix gurus, I would like to count the number occurrences of all the words (regardless of case) across multiple files, preferably outputting them in descending order of occurrence. This is well beyond my paltry shell scripting ability. Researching, I can find many scripts/commands that... (4 Replies)
Discussion started by: twjolson
4 Replies

6. Shell Programming and Scripting

How to count occurrences in a specific column

Hi, I need help to count the number of occurrences in $3 of file1.txt. I only know how to count by checking one by one and the code is like this: awk '$3 ~ /aku hanya poyo/ {++c} END {print c}' FS="\t" file1.txt But this is not wise to do as i have hundreds of different occurrences in that... (10 Replies)
Discussion started by: redse171
10 Replies

7. Shell Programming and Scripting

[Solved] Counting specific characters within each field

Hello, I have a file like following: ALB_13554 1 1 1 ALB_13554 1 2 1 ALB_18544 2 0 2 ALB_18544 1 0 1 This is a sample of my file, my real file has 441845 number of fields. What I want to do is to calculate the number of 1 and 2 in each column using AWK, so, the output file looks like... (5 Replies)
Discussion started by: Homa
5 Replies

8. UNIX for Dummies Questions & Answers

BASH - Counting word occurrences in a Web Page

Hi all, I have to do a script bash (for university) that counts all word occurrences in a specific web page. anyone can help me?. Thanks :) (1 Reply)
Discussion started by: piacentero
1 Replies

9. UNIX for Dummies Questions & Answers

Awk: Counting occurrences between two files

Hi, I have two text files (1.txt and 2.txt). 2.txt contains two columns which are extracted from 1.txt using a simple if(condition) print. I want to: - count how many times the values contained in 2.txt appear in 1.txt -if they appear just one time, I have to delete the entire row in... (5 Replies)
Discussion started by: Pintug
5 Replies

10. Shell Programming and Scripting

Counting specific column and add result in output

Hi all, I have a quick question: I have a 4 column tab-separated file. I want to count the number of times each unique value in column 2 appears and add that number in a 5th column. I have the following input file: waterline-n below-sheath-v 14.8097 A dock-n below-sheath-v ... (4 Replies)
Discussion started by: owwow14
4 Replies

LEARN ABOUT DEBIAN

sary

SARY(1) 							       Sary								   SARY(1)

NAME

       sary - manual page for sary 1.0.2

SYNOPSIS

       sary [OPTION]... PATTERN FILE

DESCRIPTION

       -c, --count
	      only print a count of occurrences

       -i, --ignore-case
	      ignore case distinctions

       -l, --lexicographical
	      sort in lexicographical order

       -A, --after-context=NUM
	      print NUM lines of trailing context

       -B, --before-context=NUM
	      print NUM lines of leading context

       -C, --context=[NUM],
	      print NUM (default 2) lines of output context

       -s, --start=TAG,
	      print tagged region. set start tag to TAG

       -e, --end=TAG,
	      print tagged region. set end tag to TAG

       -h, --help
	      display this help and exit

COPYRIGHT

       Copyright (C) 2000 Satoru Takabayashi All rights reserved.
       This  is  free  software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by
       the Free Software Foundation; either version 2.1, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY	WARRANTY;  without  even  the  implied	warranty  of  MER-
       CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.

sary 1.0.2							   December 2000							   SARY(1)
All times are GMT -4. The time now is 07:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy