Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Search and Count Occurrences of Pattern in a File Post 302325931 by joeyg on Tuesday 16th of June 2009 01:50:44 PM
Old 06-16-2009
Hammer & Screwdriver Another approach, and lesson in expressions

I copied your file to a temp file on my system, called file26.

Code:
> tr " " "\n" <file26 | grep "ADB_STFC_BAL" | wc -l
9

> tr " " "\n" <file26 | grep "PABC_CUST_ACCT_DETL_CURR.ADB_STFC_BAL" | wc -l
4

> tr " " "\n" <file26 | grep 'PABC\.CUST_ACCT_DETL_CURR.ADB_STFC_BAL' | wc -l
2

Note that I matched your first count correctly. Now take a look at the 2nd and 3rd commands. A . in grep means to match any character, so I had to do a \. to escape the . character to precisely match on it.
And 4 & 2 are the correct match counts for your input file.

By the way, I often use this trick of replacing a space character with a new line [the first tr command] when trying to find unique matching.
 

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 (9 Replies)
Discussion started by: RahulJoshi
9 Replies

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 Replies)
Discussion started by: slipstream
3 Replies

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 ... (7 Replies)
Discussion started by: ysvsr1
7 Replies

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 Replies)
Discussion started by: sheelsadan
5 Replies

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 (4 Replies)
Discussion started by: swayam123
4 Replies

6. Shell Programming and Scripting

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

Hi, file1.txt AAA BBB CCC DDD file2.txt abc|AAA|AAAabcbcs|fnwufnq bca|nwruqf|AAA|fwfwwefwef fmimwe|BBB|fnqwufw|wufbqw wcdbi|CCC|wefnwin|wfwwf DDD|wabvfav|wqef|fwbwqfwfe i need the count of rows of file1.txt present in the file2.txt required output: AAA 2 (10 Replies)
Discussion started by: mdkm
10 Replies

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... (3 Replies)
Discussion started by: ampsys
3 Replies

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... (5 Replies)
Discussion started by: quincyjones
5 Replies

9. Shell Programming and Scripting

awk variable search and line count between variable-search pattern

Input: |Running the Rsync|Sun Oct 16 22:48:01 BST 2016 |End of the Rsync|Sun Oct 16 22:49:54 BST 2016 |Running the Rsync|Sun Oct 16 22:54:01 BST 2016 |End of the Rsync|Sun Oct 16 22:55:45 BST 2016 |Running the Rsync|Sun Oct 16 23:00:02 BST 2016 |End of the Rsync|Sun Oct 16 23:01:44 BST 2016... (4 Replies)
Discussion started by: busyboy
4 Replies
arp(8c) 																   arp(8c)

Name
       arp - address resolution display and control

Syntax
       arp -a [vmunix] [kmem]
       arp [-d] hostname
       arp -f filename
       arp -s hostname ether_addr [temp] [pub] [trail]

Description
       The program displays and modifies the Internet-to-Ethernet address translation tables used by the address resolution protocol

       The hostname is the name of the host system for which information will be displayed or modified.

       With no flags, the program displays the current ARP entry for hostname.

Options
       -a   Displays current Address Resolution Protocol (ARP) entries from the specified name list and core files (next arguments).  If not spec-
	    ified, uses and respectively.

       -d   Deletes the entry for the host specified by name (next argument).

       -f   Reads information from the specified file (next argument) and modifies entries accordingly.  Entries in the file should be of the fol-
	    lowing form, with argument meanings as given previously:
	    hostname ether_addr [ temp ] [ pub ] [ trail ]

       -s   Creates an ARP entry for the host called hostname with the Ethernet address ether_addr.  The Ethernet address is given as six hexadec-
	    imal bytes separated by colons.  The entry will be permanent unless the word temp is given in the command.	If the word pub is  given,
	    the  entry will be published.  That is, the system will act as an ARP server, responding to requests for hostname even though the host
	    address is not its own.  The word trail indicates that trailer encapsulations may be sent to this host.

See Also
       arp(4p), ifconfig(8c)

																	   arp(8c)
All times are GMT -4. The time now is 02:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy