Print lines matching value(s) in other file using awk

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk to average matching lines in file

The awk below executes and is close (producing the first 4 columns in desired). However, when I add the sum of $7, I get nothing returned. Basically, I am trying to combine all the matching $4 in f1 and output them with the average of $7 in each match. Thank you :). f1 ...

2. Shell Programming and Scripting

awk to print matching lines in files that meet critera

In the tab delimited files below I am trying to match $2 in file1 to $2 of file2. If a match is found the awk checks $3 of file2 and if it is greater than 40% and $4 of file2 is greater than 49, the line in file1 is printed. In the desired output line3 of file1 is not printed because $3 off file2...

3. Shell Programming and Scripting

awk to combine matching lines in file

I am trying to combine all matching lines in the tab-delimited using awk. The below runs but no output results. Thank you :). input chrX 110925349 110925532 ALG13 chrX 110925349 110925532 ALG13 chrX 110925349 110925532 ALG13 chrX 47433390 47433999 SYN1...

4. UNIX for Dummies Questions & Answers

awk - Print lines if only matching key is found

I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. Thanks a lot. Any help is appreciated. Script I am using: awk 'FNR == NR && ! /^]*$/ {...

5. Shell Programming and Scripting

Want to print out lines with a matching pattern from file

Hi all, I want to search for strings in file1 that can be found in file2 and print out the whole line when matching pattern is found. I have used the below command, but this is not working for me, because it is writing out only the matching patterns from file2, not the whole line. fgrep -o...

6. Shell Programming and Scripting

Compare file1 for matching line in file2 and print the difference in matching lines

Hello, I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from...

7. Shell Programming and Scripting

awk print non matching lines based on column

My item was not answered on previous thread as code given did not work I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2 Here was CODE give to issue ~/unix.com$ cat f1...

8. Shell Programming and Scripting

Print matching lines in a file

Hello everyone, I have a little script below: die "Usage infile outfile reGex" if @ARGV != 3; ($regex) = @ARGV; open(F,$ARGV) or die "Can't open"; open(FOUT,"+>$ARGV") or die "Can't open"; while (<F>) { print FOUT if /$regex/.../$regex/; } No matter what I give $regex on the...

9. Shell Programming and Scripting

AIX equivalent to GNU grep's -B and -A [print lines after or before matching lines]

Hi folks I am not allowed to install GNU grep on AIX. Here my code excerpt: grep_fatal () { /usr/sfw/bin/gegrep -B4 -A2 "FATAL|QUEUE|SIGHUP" } Howto the same on AIX based machine? from manual GNU grep ‘--after-context=num’ Print num lines of trailing context after...

10. Shell Programming and Scripting

How to print file without few exactly matching lines?

Hi I have a very long file with 4 columns of numbers for example 1875 1876 12725 12723 13785 13786 4232 4230 13184 13185 ...

LEARN ABOUT PLAN9

grep

GREP(1) 						      General Commands Manual							   GREP(1)

NAME

       grep - search a file for a pattern

SYNOPSIS

       grep [ option ...  ] pattern [ file ...	]

DESCRIPTION

       Grep  searches  the input files (standard input default) for lines (with newlines excluded) that match the pattern, a regular expression as
       defined in regexp(6).  Normally, each line matching the pattern is `selected', and each selected line is copied	to  the  standard  output.
       The options are

       -c     Print only a count of matching lines.
       -h     Do not print file name tags (headers) with output lines.
       -i     Ignore alphabetic case distinctions.  The implementation folds into lower case all letters in the pattern and input before interpre-
	      tation.  Matched lines are printed in their original form.
       -l     (ell) Print the names of files with selected lines; don't print the lines.
       -L     Print the names of files with no selected lines; the converse of -l.
       -n     Mark each printed line with its line number counted in its file.
       -s     Produce no output, but return status.
       -v     Reverse: print lines that do not match the pattern.

       Output lines are tagged by file name when there is more than one input file.  (To force this tagging, include  /dev/null  as  a	file  name
       argument.)

       Care should be taken when using the shell metacharacters $*[^|()= and newline in pattern; it is safest to enclose the entire expression in
       single quotes '...'.

SOURCE

       /sys/src/cmd/grep.c

SEE ALSO

       ed(1), awk(1), sed(1), sam(1), regexp(6)

DIAGNOSTICS

       Exit status is null if any lines are selected, or non-null when no lines are selected or an error occurs.

																	   GREP(1)

Shell Programming and Scripting