How to match two fields


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to match two fields
# 8  
Old 04-26-2008
Base on your original post, you should find the most efficient player where RUN is the most important factor.

Code:
awk '
max<$2-$3      # Compare recordset efficiency score($2-$3) to max(higher efficiency score) value.
{
max=$2-$3      # If recordset has efficiency score greater that max, assign recordset efficiency score to max.
s=$0           # and assign the recordset to s variable.
}              # Loop until end of file.
END
{print s}      # At the end print the value of s, the recordset having the highest efficiency value.
'  data.file

I don't know but this questions look like a homework to me(check the forum rules).

Last edited by danmero; 04-26-2008 at 04:55 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match output fields agains two patterns

I need to print field and the next one if field matches 'patternA' and also print 'patternB' fields. echo "some output" | awk '{for(i=1;i<=NF;i++){if($i ~ /patternA/){print $i, $(i+1)}elif($i ~ /patternB/){print $i}}}' This code returnes me 'syntax error'. Pls advise how to do properly. (2 Replies)
Discussion started by: urello
2 Replies

2. UNIX for Beginners Questions & Answers

awk match two fields in two files

Hi, I have two TEST files t.xyz and a.xyz which have three columns each. a.xyz have more rows than t.xyz. I will like to output rows at which $1 and $2 of t.xyz match $1 and $2 of a.xyz. Total number of output rows should be equal to that of t.xyz. It works fine, but when I apply it to large... (6 Replies)
Discussion started by: geomarine
6 Replies

3. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing... (0 Replies)
Discussion started by: cmccabe
0 Replies

4. Shell Programming and Scripting

awk to calculate fields only if match is found

Trying to combine the matching $5 values between file1 and file2. If a match is found then the last $6 value in the match and the sum of $7 are outputted to a new file. The awk below I hope is a good start. Thank you :). file1 chr12 9221325 9221448 chr12:9221325-9221448 A2M 1... (5 Replies)
Discussion started by: cmccabe
5 Replies

5. Shell Programming and Scripting

Pattern Match and Rearrange the Fields in UNIX

For an Output like below Input : <Subject A="I" B="1039502" C="2015-06-30" D="010101010101"> Output : <Subject D="010101010101" B="1039502" C="2015-06-30" A="I"> I have been using something like below but not getting the desired output : awk -F ' ' '/Subject/ BEGIN{OFS=" ";}... (19 Replies)
Discussion started by: arunkesi
19 Replies

6. Shell Programming and Scripting

Match and subtract two fields

Not sure quite how to do this, but I am trying to use $1 of LCH.txt (exact match) to look for a match in $1 of genes.txt. If a match is found then in a new file match.txt $1 $2 ($4-$3) are copied. Example, the first record in LCH is PPT1 and that matches row 713, column 1 of genes.txt. ... (2 Replies)
Discussion started by: cmccabe
2 Replies

7. Shell Programming and Scripting

Add fields in different files only if some fields between them match

Hi everybody (first time posting here) I have a file1 that looks like > 1,101,0.1,0.1 1,26,0.1,0.1 1,3,0.1,0.1 1,97,0.5,0.5 1,98,8.1,0.218919 1,99,6.2,0.248 2,101,0.1,0.1 2,24,3.1,0.147619 2,25,23.5,0.559524 2,26,34,0.723404with 762 lines.. I have another 'similar' file2 > ... (10 Replies)
Discussion started by: murpholinox
10 Replies

8. Shell Programming and Scripting

how to match fields from different files in PERL

Howdy! I have multiple files with tab-separated data: File1_filtered.txt gnl|Amel_4.0|Group3.29 1 G R 42 42 60 15 ,.AAA.aa,aa.A.. hh00/f//hD/h/hh gnl|Amel_4.0|Group3.29 2 C Y 36 36 60 5 T.,T, LggJh gnl|Amel_4.0|Group3.29 3 A R 27 27 60 9 Gg,,.gg., B6hcc22_c File2_filtered.txt ... (3 Replies)
Discussion started by: sramirez
3 Replies

9. UNIX for Dummies Questions & Answers

Match values from 2 files and append certain fields

Hi, I need help on appending certain field in my file1.txt based on matched patterns in file2.txt using awk or sed. The blue color need to match with one of the data in field $2 in file2.txt. If match, BEGIN and FINISHED value in red will have a new value from field $3 and $4 accordingly. ... (1 Reply)
Discussion started by: redse171
1 Replies

10. Shell Programming and Scripting

Match two files and divide fields

I have two files that have the date field in common. I request your help with some script that divide each field value from file1 by the correspond field value of the file2 only when the field date is equal in both files. Thanks in advance ! This is a sample of the files file 1 12/16/2010,... (2 Replies)
Discussion started by: csierra
2 Replies
Login or Register to Ask a Question
GTETRINET(6)							   Games Manual 						      GTETRINET(6)

NAME
GTetrinet - a Tetrinet client for X using Gtk+ and GNOME-libs. SYNOPSIS
gtetrinet [options] DESCRIPTION
This manual page documents briefly the gtetrinet command. GTetrinet is a Tetrinet client using Gtk+ and GNOME-libs. Tetrinet is a variant of the popular Tetris brick game, that can be played simultaneously by 6 players. GTetrinet's goal is to remain completely compatible with the Windows, original client. Tetrinet clients need to connect to a dedicated server in order to be useful. GTetrient only provides the client part, but there are plenty of available servers around. Look at http://www.tetrinet.org/ for a list of servers. There is also an implementation of the server for UNIX, called tetrinetx. You can find more info about it in http://tetrinetx.source- forge.net/. OPTIONS
GTetrinet accepts the following options, besides the usual Gtk+/GNOME switches: -c, --connect=SERVER Connect to the specified server. -?, --help Display a summary of commandline options. -n, --nickname=NICKNAME Use the specified nickname on the servers. -t, --team=TEAM Join the specified team name for teamplay. -s, --spectate Connect to the server as an spectator. -p, --password=PASSWORD Use the given password to connect as a spectator (if needed). USAGE
To play Tetrinet, you first need to find a server where you can connect. You may try the servers at http://www.tetrinet.org/ or create your own using tetrinetx (a UNIX server, not included in this package). Once inside a server, you'll be able to communicate with other players using the PartyLine tab, see the server's highscores in the Winlist tab and the actual game in the Playing Fields tab. You can switch between the three tabs using the Alt+1, Alt+2 and Alt+3 shortcuts. Tetrinet is like Tetris, but multiplayer and with some additions. The goal of the game is to remain alive, by filling up other player's fields. There are some special blocks that can be used for your own benefit and against other players. They will appear randomly in your field, replacing previously existing blocks when you complete a line. You'll gain special blocks when you complete a line that contains one. It will be added to your inventory, which is just below your playfield. You need to use them in the order you collect them, by press- ing the number of the player you want to use it against. For example, if your active block is "Add Line" and you want to use it against Player 3, you'd have to press "3" and Player 3 would get a line added in that instant. The following blocks are available: A block Add Line will add an incomplete line to the bottom of the selected player's field. B block This will remove all the special blocks from a player's field. C block Clear Line is the opposite to Add Line; it will remove a line from the top of the selected player's field. G block The Gravity block may be very useful if applied to a field which has lots of unfilled spaces all around. Blocks over them will fall into the gaps, making the puzzle collapse significantly. N block Nuke will clear the chosen playing field completely, as if they had just started the game. It's useful to help team mates or when you are about to lose. O block Block Bomb will clear 3x3 portions of a player's field where there are other O blocks. The blocks in the 3x3 area will get scattered anywhere around the field. Q block Quake will make each of the lines in a player's field shift to the left or right, or stay as they were. R block Random will remove 10 random blocks from the selected player's field. S block Switch allows you to swap your playing field with another player. This can be a deadly block if used with a bit of strategy. HOMEPAGE
http://gtetrinet.sourceforge.net/ AUTHOR
This manual page was written by Jordi Mallach <jordi@debian.org>, for the Debian system (but may be used by others). Ka-shu Wong <zilli- dot@zillidot.net> is GTetrinet's main developer. You can find more information about GTetrinet in /usr/share/doc/gtetrinet. gtetrinet August 30, 2005 GTETRINET(6)