Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help needed regarding first 3 items in the list

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help needed regarding first 3 items in the list
# 1  
Old 05-23-2010
Help needed regarding first 3 items in the list
Hi,
I've a list in the following format:

Empdept filedetails buildingNo Area
AAA 444 2 juy
AAA 544 2 kui
AAA 567 4 poi
AAA 734 5 oiu
AAA 444 2 juy
AAB 594 2 kui
AAB 507 4 poi
AAB 764 5 oiu
AAB 444 2 juy
AAB 544 2 kui
AAB 567 4 poi
AAB 734 5 oiu
AAC 444 2 juy
AAC 544 2 kui
AAC 567 4 poi
AAC 734 5 oiu
AAC 444 2 juy
AAC 544 2 kui
AAC 567 4 poi
AAD 734 5 oiu

now this list might grow and I might have 50 AAA empdepts , 40 AAB depts and 40 AAC empdepts and so on...


Now I want to have a script which will pick only 3 (or upto 3) Empdept details from this list.. like

Empdept filedetails buildingNo Area
AAA 444 2 juy
AAA 544 2 kui
AAA 567 4 poi

AAB 594 2 kui
AAB 507 4 poi
AAB 764 5 oiu

AAC 444 2 juy
AAC 544 2 kui
AAC 567 4 poi

AAD 734 5 oiu


Please help me with a shell script which will do this very quickly...


Thanks in advance...
# 2  
Old 05-23-2010
Code:
$ awk 'A[$1]++ < 3' file1 
AAA 444 2 juy
AAA 544 2 kui
AAA 567 4 poi
AAB 594 2 kui
AAB 507 4 poi
AAB 764 5 oiu
AAC 444 2 juy
AAC 544 2 kui
AAC 567 4 poi
AAD 734 5 oiu

# 3  
Old 05-23-2010
Code:
$ awk '{print $1}' infile | uniq | while read line; do
grep -m3 "^$line" infile && echo
done

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to process a list of items and uncomment lines with that item in a second file

Hello, I have a src code file where I need to uncomment many lines. The lines I need to uncomment look like, C CALL l_r(DESNAME,DESOUT, 'Gmax', ESH(10), NO_APP, JJ) The comment is the "C" in the first column. This needs to be deleted so that there are 6 spaces preceding "CALL".... (7 Replies)
Discussion started by: LMHmedchem
7 Replies

2. Shell Programming and Scripting

Pass an array to awk to sequentially look for a list of items in a file

Hello, I need to collect some statistical results from a series of files that are being generated by other software. The files are tab delimited. There are 4 different sets of statistics in each file where there is a line indicating what the statistic set is, followed by 5 lines of values. It... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

3. What is on Your Mind?

Number of Small Forum Code Changes (TODO List Items)

In the past few days have I have done a lot of code cleanup work in various categories, including faster page loading and bug fixes: Move countless inline style directives to external CSS stylesheets for key pages (faster page loading) Fixed bug in member panel going between desktop and... (6 Replies)
Discussion started by: Neo
6 Replies

4. Shell Programming and Scripting

Read a lis, find items in a file from the list, change each item

Hello, I have some tab delimited text data, file: final_temp1 aname val NAME;r'(1,) 3.28584 r'(2,)<tab> NAME;r'(3,) 6.13003 NAME;r'(4,) 4.18037 r'(5,)<tab> You can see that the data is incomplete in some cases. There is a trailing tab after the first column for each incomplete row. I... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

5. Shell Programming and Scripting

Parsing through a list of items

Hi there, Here is my checklist of items, 4.1.1 Alerter 4.1.2 Client Services for Netware 4.1.3 Clipbook 4.1.4 Fax Service 4.1.5 File Replication 4.1.6 File Services for Macintosh 4.1.7 FTP Publishing Service 4.1.8 Help and Support 4.1.9 HTTP SSL 4.1.10 IIS Admin Service ... (1 Reply)
Discussion started by: alvinoo
1 Replies

6. Web Development

List items not arranged as expected on web page

greetings, i have a list of items that are picks to be arranged within a row that is 22 in height. this "plugin" looks fine in the old installation but after installing a new version of the web app and dropping this "plugin" in place the layout isn't as i expect. they are arranged vertically... (1 Reply)
Discussion started by: crimso
1 Replies

7. Shell Programming and Scripting

Shell Script Needed to Read a text from a list files

Hi, Below is my issue which I desperately need and I want a shell script which can do this job. I need this script as I m planning to put this for a system health check. Please assist me. 1. There are 10 log files in a particular location. 2. open each log file. Goto to the end of the... (4 Replies)
Discussion started by: kashriram
4 Replies

8. Shell Programming and Scripting

awk between items including items

OS=HP-UX ksh The following works, except I want to include the <start> and <end> in the output. awk -F '<start>' 'BEGIN{RS="<end>"; OFS="\n"; ORS=""} {print $2} somefile.log' The following work in bash but not in ksh sed -n '/^<start>/,/^<end>/{/LABEL$/!p}' somefile.log (4 Replies)
Discussion started by: Ikon
4 Replies

9. Shell Programming and Scripting

change list to comma seperated items

I have a list of servers in a file called serverlist like this server1 server2 server3 i need to have them (with no trailing comma, the program does not like that) server1,server2,server3 so far i have been using HOSTS=/tmp/serverlist HOSTS=${HOSTS:-$(grep -Ev "^#|^$"... (2 Replies)
Discussion started by: insania
2 Replies
Login or Register to Ask a Question