Compare and extract

ford2020 · #1 (**permalink**) 05-15-2009

Compare two files, search for data from position 1-6 if both matches then i need to extract those records only from file A

cat File A
A37985LUNGIUF7845049530113
F41604CHACAMA286000004371

cat File B
C26344
F41604

o/p
F41604CHACAMA286000004371

vgersh99 · #2 (**permalink**) 05-15-2009

Code:

nawk 'FNR==NR {a[substr($0,1,6)]++;next} substr($0,1,6) in a' fileB fileA

ford2020 · #3 (**permalink**) 05-15-2009

I am getting error
-bash: nawk: command not found

vgersh99 · #4 (**permalink**) 05-15-2009

try awk or gawk (obviously)

ford2020 · #5 (**permalink**) 05-15-2009

i tried using awk
awk: cmd. line:1: FNR=NR {a[substr($0,1,6)]++;next} substr($0,1,6) in a}
awk: cmd. line:1: ^ parse r

ford2020 · #6 (**permalink**) 05-15-2009

I am not able to do by gawk also....
gawk: cmd. line:1: FNR=NR {a[substr($0,1,6)]++;next} substr($0,1,6) in a}
gawk: cmd. line:1: ^ parse

vgersh99 · #7 (**permalink**) 05-15-2009

I'm not sure if you copy/pasted it correctly - check the posting.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Using grep to compare files and extract the difference to another output file	spartan22	UNIX for Dummies Questions & Answers	6	02-23-2009 04:51 PM
Compare two arrays in sh or compare two fields	rijeshpp	Shell Programming and Scripting	0	10-31-2007 02:47 AM
I need to extract last column of a file and compare the values	vukkusila	Shell Programming and Scripting	4	08-04-2007 12:21 PM
compare two tar.bz2	JCR	Shell Programming and Scripting	2	07-30-2007 12:16 PM
How to compare it ??	sabercats	Shell Programming and Scripting	4	02-16-2006 06:07 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: