How to count pattern in column

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

If pattern in column 3 matches pattern in column 2 (any row), print value in column 1

Hi all, I have searched and searched, but I have not found a solution that quite fits what I am trying to do. I have a long list of data in three columns. Below is a sample: 1,10,8 2,12,10 3,13,12 4,14,14 5,15,16 6,16,18 Please use code tags What I need to do is as follows: If a...

2. Shell Programming and Scripting

Column 2 string count in Column 3

3. Shell Programming and Scripting

Read first column and count lines in second column using awk

Hello all, I would like to ask your help here: I've a huge file that has 2 columns. A part of it is: sorted.txt: kss23 rml.67lkj kss23 zhh.6gf kss23 nhd.09.fdd kss23 hp.767.88.89 fl67 nmdsfs.56.df.67 fl67 kk.fgf.98.56.n fl67 bgdgdfg.hjj.879.d fl66 kl..hfh.76.ghg fl66...

4. Shell Programming and Scripting

Identify file pattern, take count of pattern, then act

Guys - Need your ideas on a section of code to finish something up. To make a long story short, I'm parsing a print output file that goes to pre-printed forms. I'm intercepting it, parsing it, formatting it, cutting it up into individual pages, grabbing the text I want in zones, building an...

5. Shell Programming and Scripting

awk pattern match and count unique in column

Hi all I have a need of searching some pattern in file by month and then count unique records D11 G11 R11 -------> Pattern available in file S11 Jan$1 to $5 column contains some records in which I want to find unique for this purpose I have written script like below awk '/Jan/ ||...

6. Shell Programming and Scripting

Search for a pattern in a String file and count the occurance of each pattern

I am trying to search a file for a patterns ERR- in a file and return a count for each of the error reported Input file is a free flowing file without any format example of output ERR-00001=5 .... ERR-01010=10 ..... ERR-99999=10

7. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........

8. Shell Programming and Scripting

need to remove duplicates based on key in first column and pattern in last column

Given a file such as this I need to remove the duplicates. 00060011 PAUL BOWSTEIN ad_waq3_921_20100826_010517.txt 00060011 PAUL BOWSTEIN ad_waq3_921_20100827_010528.txt 0624-01 RUT CORPORATION ad_sade3_10_20100827_010528.txt 0624-01 RUT CORPORATION ...

9. Shell Programming and Scripting

Count the number of occurrences of a pattern between each occurrence of a different pattern

I need to count the number of occurrences of a pattern, say 'key', between each occurrence of a different pattern, say 'lu'. Here's a portion of the text I'm trying to parse: lu S1234L_149_m1_vg.6, part-att 1, vdp-att 1 p-reserver IID 0xdb registrations: key 4156 4353 0000 0000 ...

10. Shell Programming and Scripting

nawk-how count the number of occurances of a pattern, when don't know the pattern

I've written a script to count the total size of SAN storage LUNs, and also display the LUN sizes. From server to server, the LUNs sizes differ. What I want to do is count the occurances as they occur and change. These are the LUN sizes: 49.95 49.95 49.95 49.95 49.95 49.95 49.95 49.95...

LEARN ABOUT SUSE

histo

HISTO(1)						      General Commands Manual							  HISTO(1)

NAME

       histo - compute 1-dimensional histogram of N data columns

SYNOPSIS

       histo [-c][-p] xmin xmax nbins
       histo [-c][-p] imin imax

DESCRIPTION

       Histo  bins columnular data on the standard input between the given minimum and maximum values.	If three command line arguments are given,
       the third is taken as the number of data bins between the first two real numbers.  If only two arguments are given, they are  both  assumed
       to be integers, and the number of data bins will be equal to their difference plus one.	The bins are always of equal size.

       The  output is N+1 columns of data (for N columns input), where the first column is the centroid of each division, and each row corresponds
       to the frequencies for each column around that value.

       If the -c option is present, then histo computes the cumulative histogram for each column instead of the straight frequencies.	The  upper
       value  of  each	bin  is printed also instead of the centroid.  This may be useful in computing percentiles, for example.  Values below the
       minimum specified are still counted in the cumulative total.

       The -p option tells histo to report the percentage of the total number of input lines rather than the absolute counts.  In the  case  of  a
       cumulative total, this yields the percentile values directly.  Values above the maximum are counted as well as values below in this case.

       All  input data is interpreted as real values, and columns must be white-space separated.  If any value is less than the minimum or greater
       than the maximum, it will be ignored unless the -c option is specified.

EXAMPLE

       To count data values between -1 and 1 in 50 bins:

	 histo -1 1 50 < input.dat

       To count frequencies of integers between 0 and 255:

	 histo 0 255 < input.dat

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1), total(1)

RADIANCE
							      9/6/96								  HISTO(1)

Shell Programming and Scripting