Search and Count Occurrences of Pattern in a File Post: 302322261

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Search and Count Occurrences of Pattern in a File Post 302322261 by tektips on Wednesday 3rd of June 2009 08:25:14 AM

06-03-2009

Registered User

Search and Count Occurrences of Pattern in a File

I need to search and count the occurrences of a pattern in a file. The catch here is it's a pattern and not a word ( not necessarily delimited by spaces). For eg. if ABCD is the pattern I need to search and count, it can come in all flavors like (ABCD, ABCD), XYZ.ABCD=100, XYZ.ABCD>=500, XYZ.ABCD = 200 etc.

I tried using something like below for Word search and count ( got if from another post trying to count occurrences of word , but not sure how I could fit this in for a string which is not necessarily delimited.

Code:

srchWord="$1"
srchFilename="$2"
ctr=0
    while read strLine
    do
    for eachWord in `echo $strLine`
    do
    if [ "$eachWord" = "$srchWord" ]
    then
    ctr=`expr $ctr + 1`
    fi
    done
    done < srchFilename
    printf "\n\ntheFile contains %s : %d times\n\n" $srchWord $ctr

Example of file contents and two specific search scenarios I am trying to address

Code:

(
PABC_CUST_ACCT_DETL_CURR.ADB_STFC_BAL<=5000
OR
PABC_CUST_ACCT_DETL_CURR.ADB_STFC_BAL is NULL
)
lab_may09_params_tbl.AMF <= 59)
((PABC.CUST_ACCT_DETL_CURR.ADB_STFC_BAL <= 5000) OR PABC.CUST_ACCT_DETL_CURR.ADB_STFC_BAL IS NULL) 
(ADB_STFC_BAL=100
ADB_STFC_BAL)
PABC_CUST_ACCT_DETL_CURR.ADB_STFC_BAL^M
PABC_CUST_ACCT_DETL_CURR.ADB_STFC_BAL;
(ADB_STFC_BAL)^M

Scenarios which I need to address:-

1. Search by ADB_STFC_BAL
Expected Result : Count 9

2. Search by PABC_CUST_ACCT_DETL_CURR.ADB_STFC_BAL
Expected Result : Count 6

Any help with altering the above script to use the pattern or any ather approaches to solve the problem using awk or so are greatly appreciated. Files are pretty large and I need to do this for around 200 words.

Thanks in advance !

tektips

View Public Profile for tektips

Find all posts by tektips

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pattern search and count

i want to search a word in a file and find the count of occurences even if pattern occures twice in a same line. for example file has the following content. yes no no nooo yees no yes if I search for "no" it should give count as 4 Pls help. Thanks

2. 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 ...

3. Shell Programming and Scripting

Pattern search and count

Hi all, I need to search the database log find out the most frequently used tables for a certain period of time. The search pattern is : the database.table so, i need to look for ABCD.* in the entire log and then need the top ten tables. I thought of using awk, search for the pattern ...

4. Shell Programming and Scripting

How to search number of occurrences of a particular string in a file through vi editor?

i have one file, i am doing 'vi Filename' now i want to search for particular string and i want to know how many times that string occurs in whole file

5. 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

6. Shell Programming and Scripting

Speed : awk command to count the occurrences of fields from one file present in the other file

7. 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...

8. Shell Programming and Scripting

Count occurrences in first column

input amex-11 10 abc amex-11 20 bcn amed-12 1 abc I tried something like this. awk '{h++}; END { for(k in h) print k, h }' rm1 output amex-11 1 10 abc amex-11 1 20 bcn amed-12 2 1 abc Note: The second column represents the occurrences. amex-11 is first one and amed-12 is the...

9. Shell Programming and Scripting

awk variable search and line count between variable-search pattern

LEARN ABOUT MINIX

grep

GREP(1) 						      General Commands Manual							   GREP(1)

NAME

       grep - search a file for lines containing a given pattern

SYNOPSIS

       grep [-elnsv] pattern [file] ...

OPTIONS

       -e     -e pattern is the same as pattern

       -c     Print a count of lines matched

       -i     Ignore case

       -l     Print file names, no lines

       -n     Print line numbers

       -s     Status only, no printed output

       -v     Select lines that do not match

EXAMPLES

       grep mouse file	   # Find lines in file containing mouse

       grep [0-9] file	   # Print lines containing a digit

DESCRIPTION

       Grep  searches  one  or	more  files (by default, stdin) and selects out all the lines that match the pattern.  All the regular expressions
       accepted by ed and mined are allowed.  In addition, + can be used instead of * to mean 1 or more occurrences, ? can be used to mean 0 or  1
       occurrences,  and  |  can  be used between two regular expressions to mean either one of them.  Parentheses can be used for grouping.  If a
       match is found, exit status 0 is returned.  If no match is found, exit status 1 is returned.  If an error is detected,  exit  status  2	is
       returned.

SEE ALSO

       cgrep(1), fgrep(1), sed(1), awk(9).

																	   GREP(1)