|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to match two fields
Post 302189549 by Prahlad on Saturday 26th of April 2008 11:33:18 AM
04-26-2008
----------
awk 'max<$2-$3{max=$2-$3;s=$0}END{print s}'
-----------
Hello danmero,
Yes , it works great.
Could u plz share the logic with me ?
Thanks,
awk 'max<$2-$3{max=$2-$3;s=$0}END{print s}'
-----------
Hello danmero,
Yes , it works great.
Could u plz share the logic with me ?
Thanks,
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. UNIX for Beginners Questions & Answers
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
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
mpris-remote
MPRIS-REMOTE(1) mpris-remopte Manual MPRIS-REMOTE(1) NAME
mpris-remote - control mpris compatible audio players SYNOPSIS
mpris-remote [ options ] DESCRIPTION
mpris is a dbus standard interface to control media players. Many players like amarok, Audacious, QMMP, mpd with mpDris support this interface. mpris-remote is a command-line interface to control media players via mpris. OPTIONS
-h, --help Prints usage of mpris-remote and exit. addtrack uri [true] Add track at specified uri to media-player. Filetypes, protocols, locations are dependent on the media player. If true is specified starts immediate playback of added track. uri can be set to - to read uris from stdin. clear Clear current playlist. deltrack tracknumber Remove tracknumber from current playlist. identity: Print the identity of the player. Typically version and name. loop [true|false] If the parameter is omitted prints whether media player will loop track list. Otherwise sets whether track list loops or not. next Next track. numtrack Prints number of tracks in current playlist. play Start playback playstatus Print information about the current status of the player. prev, previous Previous track. position Prints position in current track random [true|false] If the parameter is omitted prints whether media player has random/shuffle enabled. Otherwise set random/shuffle status. repeat [true|false] Set current track repeat. seek time Seeks to specified time in track. time is specified as milliseconds from 0. stop Stop playback trackinfo [track] Prints trackinfo. If track is committee prints trackinfo for current track. If track is * prints trackinfo for all tracks in playlist. tracknum Prints track number in current playlist volume [PERCENT] If percent is omitted returns current volume. Otherwise sets player volume to specified percentage. quit Exit player. ENVIRONMENT VARIABLES
MPRIS_REMOTE_PLAYER If unset or set to *, mpris-remote will communicate with the first player it finds registered under "org.mpris.*" through D-BUS. If you only have one MPRIS-compliant player running, then this will be fine. If you have more than one running, you will want to set this variable to the name of the player you want to connect to. For example, if set to foo, it will try to communicate with the player at "org.mpris.foo" and will fail if nothing exists at that name. SEE ALSO
For more information about mpris see http://www.mpris.org/1.0/spec.html AUTHOR
mpris-remote was written by Nick Welch <nick@incise.org>. mpris-remote 08/06/2010 MPRIS-REMOTE(1)