combine duplicate records - Page 2

kshuser · #1 (**permalink**) 4 Weeks Ago

In your awk code below where is the input file we are passing and where is outfile, i see "a" in your code is this the input file name....??? i also see word "file"..is this INPUT or OUTPUT file..?? what is this doing...???

thanks

# awk 'NF{a[substr($0,0,9)]=(a[substr($0,0,9)])?a[substr($0,0,9)] FS substr($0,34,7):$0}END{for(i in a)print a[i]}' file

danmero · #2 (**permalink**) 4 Weeks Ago

Code:

awk 'NF{a[substr($0,0,9)]=(a[substr($0,0,9)])?a[substr($0,0,9)] FS substr($0,34,7):$0}END{for(i in a)print a[i]}' Input_file > Output_file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Need awk script for removing duplicate records	nmumbarkar	Linux	6	04-09-2009 01:05 PM
find duplicate records... again	rleal	Shell Programming and Scripting	4	01-28-2009 06:30 PM
How to remove duplicate records with out sort	svenkatareddy	Shell Programming and Scripting	19	06-11-2008 02:10 PM
How to remove duplicate records with out sort	svenkatareddy	SUN Solaris	2	02-28-2008 08:38 AM
Records Duplicate	ganesh123	Shell Programming and Scripting	9	02-22-2007 08:47 AM

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: