The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
KSH Script Q. KSH Script Q.
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

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 03:06 AM
here document to automate perl script that call script hogger84 Shell Programming and Scripting 3 10-22-2007 10:15 AM
returning to the parent shell after invoking a script within a script gurukottur Shell Programming and Scripting 5 09-26-2006 07:05 AM
return valuse from child script to parent script borncrazy Shell Programming and Scripting 1 08-20-2004 03:39 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 11-21-2007
roadwest roadwest is offline
Registered User
  
 

Join Date: Nov 2007
Posts: 2
KSH Script Q.
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
  #2 (permalink)  
Old 11-21-2007
vgersh99's Avatar
vgersh99 vgersh99 is online now Forum Staff  
Moderator
  
 

Join Date: Feb 2005
Location: Boston, MA
Posts: 5,116
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]
}
  #3 (permalink)  
Old 11-21-2007
roadwest roadwest is offline
Registered User
  
 

Join Date: Nov 2007
Posts: 2
Perfect. Thank you
Sponsored Links
Closed Thread

Bookmarks

« need scripting help | IF condition failing in a SSH script »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:04 AM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language translation by Google.
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0