Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Grep Line with Matching Fields
Top Forums UNIX for Advanced & Expert Users Grep Line with Matching Fields Post 302131241 by vgersh99 on Thursday 9th of August 2007 06:31:59 PM
Old 08-09-2007
Quote:
Originally Posted by hemangjani
vgersh99,

The previous sample was the last 10 lines from both files.
For the below sample, I made sure that there few matches.

Code:
file1:

1000FAAA,100706,11446
1000FAAA,1067050,12239
1000FAAA,1081989,24010
1000FAAA,111273,26019
1000FAAA,1130922,13608
1000FAAA,11554,10214
1000FAAA,1424483,11564
1000FAAA,160237,8409
1000FAAA,255794,29390
1000FAAA,264869,8663

file2:

000000E8F900496,13492,E8F900,1000FAAA,100706,11446
0000001768X0496,13492,1768X0,1000FAAA,1067050,12239
000000354923496,13492,354923,1000FAAA,1081989,24010
00000029R018496,13492,29R018,1000FAAA,1424483,11564
0000000Y495R496,13492,0Y495R,1000FAAA,160237,8409
0000003W5R34496,13492,3W5R34,1000FAAA,255794,29390
0000002AA859496,13492,2AA859,1000FAAA,264869,8663
000000E70311496,13492,E70311,1000FAAA,309934,30127
000000R99462496,13492,R99462,1000FAAA,394836,8279
000000063EW7496,13492,063EW7,1000FAAA,421058,10314
0000000960FF496,13492,0960FF,1000FAAA,437530,11282
000000351795496,13492,351795,1000FAAA,513053,22251

Output:

000000E8F900496,13492,E8F900,1000FAAA,100706,11446
0000001768X0496,13492,1768X0,1000FAAA,1067050,12239
000000354923496,13492,354923,1000FAAA,1081989,24010
00000029R018496,13492,29R018,1000FAAA,1424483,11564
0000000Y495R496,13492,0Y495R,1000FAAA,160237,8409
0000003W5R34496,13492,3W5R34,1000FAAA,255794,29390
0000002AA859496,13492,2AA859,1000FAAA,264869,8663

Given the sample files above and an awk solution, I get the exact desired output as posted.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to grep / zgrep to output ONLY the matching filename and line number?

Hi all, I am trying to zgrep / grep list of files so that it displays only the matching filename:line number and does not display the whole line, like: (echo "1.txt";echo "2.txt") | xargs zgrep -no STRING If I use -o option, it displays the matching STRING and if not used, displays the... (3 Replies)
Discussion started by: vvaidyan
3 Replies

2. Shell Programming and Scripting

matching 2 exact fields

Dear experts, I have a file1 that looks like 60127930928 2091 60129382039 2092 60126382937 2091 60128937928 2061 60127329389 2062 60123748730 2061 60128730293 2061 and file 2 that looks like 60127930928 2091 60129382039 2092 60126382937 2093 60128937928 2061 60127329389... (2 Replies)
Discussion started by: aismann
2 Replies

3. Shell Programming and Scripting

Matching by key fields

I have a file (key.dat) that contains two columns: AA|1234| BB|567| CC|8910| I have another file (extract.dat) that contains some data: SD|458|John|Smith| AA|3345|Frank|Williams| AA|1234|Bill|Garner| BD|0098|Yu|Lin| BB|567|Gail|Hansen| CC|8910|Ken|Nielsen| I want to compare the... (5 Replies)
Discussion started by: ChicagoBlues
5 Replies

4. Shell Programming and Scripting

find out line number of matching string using grep

Hi all, I want to display line number for matching string in a file. can anyone please help me. I used grep -n "ABC" file so it displays 6 ABC. But i only want to have line number,i don't want that it should prefix matching context with line number. Actually my original... (10 Replies)
Discussion started by: sarbjit
10 Replies

5. Linux

matching two fields

Hi I am having 2 fields and if f1=f2 i wanna print that line eg 1 2 1 3 1 9 2 2 3 5 9 9 In the abov eg. the highlighted lines shud be printed 2 2 9 9 Thanking u (3 Replies)
Discussion started by: binnybio
3 Replies

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

7. Shell Programming and Scripting

Grep log file to get line above matching pattern

Hi, I have a log file that looks like this "delete" : { "_type" : "cl", "_id" : "1000600000000562636", "_version" : 1, "status" : 200, "found" : false } }, { "delete" : { "_type" : "cl", "_id" : "1000600000000562643", ... (4 Replies)
Discussion started by: wahi80
4 Replies

8. Shell Programming and Scripting

awk to combine all matching fields in input but only print line with largest value in specific field

In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited, that are in $1 of gene which is just a single column of text. However only the line with the greatest $9 value in input needs to be printed. So in the example below all the MECP2 and LTBP1... (0 Replies)
Discussion started by: cmccabe
0 Replies

9. UNIX for Beginners Questions & Answers

Grep file starting from pattern matching line

I have a file with a list of references towards the end and want to apply a grep for some string. text .... @unnumbered References @sp 1 @paragraphindent 0 2017. @strong{Chalenski, D.A.}; Wang, K.; Tatanova, Maria; Lopez, Jorge L.; Hatchell, P.; Dutta, P.; @strong{Small airgun... (1 Reply)
Discussion started by: kristinu
1 Replies

10. Shell Programming and Scripting

How to control grep output intact for each matching line?

I have multiple (~80) files (some can be as big as 30GB of >1 billion of lines!) to grep on a pattern, and piped the match to a single file. I have a 96-core machine so that each grep job was sent to the background to speed up the search: file1.tab chr1A_part1 123241847 123241848... (6 Replies)
Discussion started by: yifangt
6 Replies

LEARN ABOUT DEBIAN

oakdecode

oakdecode(1)						      General Commands Manual						      oakdecode(1)

NAME

       oakdecode - Decode an OAKT printer stream into human readable form.

SYNOPSIS

       oakdecode [options] <OAKT-file

DESCRIPTION

       oakdecode decodes an OAKT printer stream into human readable form.

       An OAKT printer stream is the printer langauge used by the HP Color LaserJet 1500 and other printers.

COMMAND LINE OPTIONS

       These are the options that can appear on the command line.

       -d basename
	      Basename of .pbm file for saving decompressed planes.

       -r basename
	      Basename of .jbg file for saving raw planes

       -i     Suppress display of image records.

       -o     Print file offsets.

       -D level
	      Set Debug level [0].

EXAMPLES

       Decode an OAKT file created by foo2oak.

       $ oakdecode < testpage.oak
       0d(80) 1 OTHER
       0c(64) Wed Nov 05 16:30:50 2003        a07d3   100005  32001e
       0a(80) testpage.pdf
       14(16) (no args)
       28(16) Source=Tray1
       29(80) PaperType=0 UNK8=2,0,0,0, blanks(63)
       2a(32) Copies=1        UNK=0
       2b(32) papercode=25    xwid=4648       ywid=9000       UNK=0
       33(64)
	       u0      u1      w       h       resx    resy    nBits
	       x0      x0      2128    4300    600     600     x1
       15(16) (no args)
	    bih0     w	   h	l0     bih5   dlen  plen unk yOff P subP
       3c(64) 00010000 2176  256  256 58030020  1050  1056 000   64 3 0
		       DL = 0, D = 0, P = 1, - = 0, XY = 2176 x 256
		       L0 = 256, MX = 32, MY = 0
		       Order   = 3  ILEAVE SMID
		       Options = 88  LRLTWO TPDON TPBON
		       1 stripes, 0 layers, 1 planes
       3c(64) 00010000 2176  256  256 58030020  3668  3680 000  320 3 0
       3c(64) 00010000 2176  256  256 58030020  1463  1472 000  640 3 0
       3c(64) 00010000 2176  256  256 58030020  1975  1984 000  896 3 0
       3c(64) 00010000 2176  224  224 58030020  2744  2752 000 1152 3 0
       3c(64) 00010000 2176  256  256 58030020   988	992 000 1440 3 0
       3c(64) 00010000 2176  256  256 58030020  2892  2896 000 1696 3 0
       3c(64) 00010000 2176  256  256 58030020  3634  3648 000 1952 3 0
       3c(64) 00010000 2176  256  256 58030020  3236  3248 000 2208 3 0
       3c(64) 00010000 2176  256  256 58030020  2279  2288 000 2464 3 0
       3c(64) 00010000 2176  256  256 58030020  3746  3760 000 2720 3 0
       3c(64) 00010000 2176  200  200 58030020  2404  2416 000 2976 3 0
       3c(64) 00010000 2176  256  256 58030020  3114  3120 000 3240 3 0
       3c(64) 00010000 2176   96   96 58030020  1142  1152 000 3496 3 0
       3c(64) 00010000 2176  256  256 58030020  2094  2112 000 3752 3 0
       3c(64) 00010000 2176  256  256 58030020  1319  1328 000 4008 3 0
       3c(64) 00010000 2176   36   36 58030020   208	224 000 4264 3 0
       17(16) (no args)
       18(16) UNK=0
       0b(16) (no args)

FILES

       /usr/bin/oakdecode

SEE ALSO

       foo2oak-wrapper(1), foo2oak(1), jbg2pbm(1)

AUTHOR

       Rick Richardson <rick.richardson@comcast.net>
       http://foo2oak.rkkda.com/
All times are GMT -4. The time now is 04:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy