Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

Using awk instead of grep -f

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Using awk instead of grep -f
# 1  
Old 11-07-2019
Using awk instead of grep -f
Hi Guys.
I am trying to count occurances of patterns(occurance can be anywhere in file2) from file1 in file2.
file1 is
Code:
god
god
pod 
rod
file2 is
iamgod
iamgod
podrod
123rod456

output should be
Code:
god 2
god 2
pod 1
rod 2

I am not good at awk but i figured out this command.it doesnt give me desired output.
Code:
awk -F "god" '{s+=(NF-1)} END {print s}' file2

Can someone help please.
Thank you
Sam

--- Post updated at 09:09 AM ---

i also have this awk script but its not giving me desired output
Code:
#!/usr/bin/awk -f
FNR==NR {
  f2[$0]
  next
}
{
  for(i in f2) {
    if($0 ~ (i))
      beg[i]++
    if($0 ~ (i"$")) {
      end[i]++
  }
}
}
END {
    print "anywhere"
    for(i in f2)
       print i,beg[i]+0
}

Last edited by vbe; 11-07-2019 at 09:42 AM.. Reason: code tags please
# 2  
Old 11-07-2019
Hey.

What OS and shell are you using?
# 3  
Old 11-07-2019
Quote:
Originally Posted by Neo
Hey.

What OS and shell are you using?
Debian bash
# 4  
Old 11-07-2019
Would this come close?
Code:
grep -offile1 file2 | sort | uniq -c
      2 god
      1 pod
      2 rod

--- Post updated at 16:24 ---

Hoppla - didn't take your thread title into account. Try this awk:
Code:
awk '
FNR==NR {OUT[NR] = $1
         CNT[$1]
         MX = NR
         next
        }
        {for (c in CNT) if (match ($0, c)) CNT[c]++
        }
END     {for (i=1; i<=MX; i++) print OUT[i], CNT[OUT[i]]
        }
' file[12]
god 2
god 2
pod 1
rod 2

These 2 Users Gave Thanks to RudiC For This Post:
ahfze Neo
# 5  
Old 11-07-2019
Thanks,
i think this works.testing it for a big file.
just one thing.
i am trying to put the codes in a .awk file and then run it.
i would like to run it like
Code:
perl script.awk input1 input2 >output

how can i do this?


Quote:
Originally Posted by RudiC
Would this come close?
Code:
grep -offile1 file2 | sort | uniq -c
      2 god
      1 pod
      2 rod

--- Post updated at 16:24 ---

Hoppla - didn't take your thread title into account. Try this awk:
Code:
awk '
FNR==NR {OUT[NR] = $1
         CNT[$1]
         MX = NR
         next
        }
        {for (c in CNT) if (match ($0, c)) CNT[c]++
        }
END     {for (i=1; i<=MX; i++) print OUT[i], CNT[OUT[i]]
        }
' file[12]
god 2
god 2
pod 1
rod 2

# 6  
Old 11-07-2019
perl?
# 7  
Old 11-07-2019
sorry
i meant awk
Code:
awk -f  script.awk file1  file2>output

can i mention the file1 and file2 using above command.
could you modify the script you gave me?
thanks
Last edited by Scrutinizer; 11-07-2019 at 04:54 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed and awk usage to grep a pattern 1 and with reference to this grep a pattern 2 and pattern 3

Hi , I have a file where i have modifed certain things compared to original file . The difference of the original file and modified file is as follows. # diff mir_lex.c.modified mir_lex.c.orig 3209c3209 < if(yy_current_buffer -> yy_is_our_buffer == 0) { --- >... (5 Replies)
Discussion started by: breezevinay
5 Replies

2. UNIX for Dummies Questions & Answers

Piping grep into awk, read the next line using grep

Hi, I have a number of files containing the information below. """"" Fundallinfo 6.3950 14.9715 14.0482 """"" I would like to grep for Fundallinfo and use it to read the next line? I ideally would like to read the three numbers that follow in the next line and... (2 Replies)
Discussion started by: Paul Moghadam
2 Replies

3. Shell Programming and Scripting

awk / grep

how do I change this line to use the awk command RC19=`grep -c "Broken pipe" $FTP_OUT` Code tags please (5 Replies)
Discussion started by: mbmarciniak
5 Replies

4. Shell Programming and Scripting

AWK/GREP: grep only lines starting with integer

I have an input file 12.4 1.72849432773174e+01 -7.74784188610632e+01 12.5 9.59432114416327e-01 -7.87018212757537e+01 15.6 5.20139995965960e-01 -5.61612429666624e+01 29.3 3.76696387248366e+00 -7.42896194101892e+01 32.1 1.86899877018077e+01 -7.56508762501408e+01 35 6.98857157014640e+00... (2 Replies)
Discussion started by: chrisjorg
2 Replies

5. Shell Programming and Scripting

Read content between xml tags with awk, grep, awk or what ever...

Hello, I trying to extract text that is surrounded by xml-tags. I tried this cat tst.xml | egrep "<SERVER>.*</SERVER>" |sed -e "s/<SERVER>\(.*\)<\/SERVER>/\1/"|tr "|" " " which works perfect, if the start-tag and the end-tag are in the same line, e.g.: <tag1>Hello Linux-Users</tag1> ... (5 Replies)
Discussion started by: Sebi0815
5 Replies

6. Shell Programming and Scripting

Is it better to grep and pipe to awk, or to seach with awk itself

This may just be a lack of experience talking, but I always assumed that when possible it was better to use a commands built in abilities rather than to pipe to a bunch of commands. I wrote a (very simple) script a while back that was meant to pull out a certain error code, and report back what... (4 Replies)
Discussion started by: DeCoTwc
4 Replies

7. Shell Programming and Scripting

MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else

Hi Guys, I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys. MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' ` Harby. (4 Replies)
Discussion started by: hariza
4 Replies

8. UNIX for Dummies Questions & Answers

grep and awk

I have grep MHz psrinfo-v.out it gives The i386 processor operates at 3000 MHz, The i386 processor operates at 3000 MHz, The i386 processor operates at 3000 MHz, The i386 processor operates at 3000 MHz, how to get instead of these 4 lines: CPU speed: 3000 MHz i.e. CPU... (3 Replies)
Discussion started by: melanie_pfefer
3 Replies

9. Shell Programming and Scripting

[grep awk cut] > awk

Hi, I'm very new to scripting. grep $s $filename | awk '{print $2}' | cut -c 1-8 How can I optimize this using a single awk? I tried: awk '/$s/ {print $2}' $filename | cut -c 1-8 However didn't work, I think the awk is not recognizing $s and the verbal is something else. (6 Replies)
Discussion started by: firdousamir
6 Replies

10. Shell Programming and Scripting

awk or grep

Urgent File contains: baba¦kkek¦aklk¦¦¦ bnbnbn¦vmvm¦ File name: Openfile I want to find number of pipe(¦) symbols in a file(count).That is total count of pipes in a file or a line. I dont want number of line it occurs. (4 Replies)
Discussion started by: tkbharani
4 Replies
Login or Register to Ask a Question