KSH Script Q.

roadwest · #1 (**permalink**) 11-21-2007

Hi all,

Can anyone help me out with a simple awk routine (or alternative) that will
read in and collate all the $1 values into a single line?

Input;
4134,Bloggs,Joe,802437394
4189,Bloggs,Joe,802437394
3234,Soap,Joe,824324999
4012,Bloggs,Joe,802437394
3425,Soap,Joe,824324999
1232,Blunt,James,803423421

Output;
Bloggs,Joe,802437394,4134,4189,4012
Soap,Joe,824324999,3234,3425
Blunt,James,803423421,1232

vgersh99 · #2 (**permalink**) 11-21-2007

nawk -f road.awk myFile

road.awk

Code:

BEGIN {
   FS=OFS=","
}
{
  idx=$2 OFS $3 OFS $4
  a[ idx ] = ( idx in a) ? a[idx] OFS $1 : $1
}
END {
  for(i in a)
    print i, a[i]
}

roadwest · #3 (**permalink**) 11-21-2007

Perfect. Thank you

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
help me in sending parameters from sqlplus script to unix shell script	Hara	Shell Programming and Scripting	2	01-29-2008 03:31 PM
Shell Script: want to insert values in database when update script runs	ring	Shell Programming and Scripting	1	10-25-2007 04:06 AM
here document to automate perl script that call script	hogger84	Shell Programming and Scripting	3	10-22-2007 11:15 AM
returning to the parent shell after invoking a script within a script	gurukottur	Shell Programming and Scripting	5	09-26-2006 08:05 AM
return valuse from child script to parent script	borncrazy	Shell Programming and Scripting	1	08-20-2004 04:39 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:


	Powered by