|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to match two fields
Post 302184709 by Franklin52 on Saturday 12th of April 2008 02:33:56 PM
04-12-2008
|
|
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 REDHAT
longrun
LONGRUN(1) General Commands Manual LONGRUN(1) NAME
Transmeta(TM) Crusoe(TM) LongRun(TM) utility SYNOPSIS
longrun [-c device] [-m device] [-hlpv] [-f flag] [-s low high] DESCRIPTION
The longrun utility is used to control and query LongRun settings on Transmeta Crusoe processors. -c device Set the CPUID device. The default CPUID device is /dev/cpu/0/cpuid. -m device Set the MSR device. The default CPUID device is /dev/cpu/0/msr. -h Print help. -l List LongRun information about available performance levels for the CPU. The following values are reported on all Transmeta CPUs that implement LongRun. % An available performance level, expressed as a percentage of range of available core CPU frequencies. 0 corresponds to the lowest available frequency and 100 corresponds to the highest. MHz The core CPU frequency at that level. Volts The core CPU voltage at that level. usage The power usage relative to the maximum performance level. -p Print current LongRun settings and status: whether LongRun is enabled, whether LongRun Thermal Extensions are active, the current LongRun performance window (expressed as a percentile range), the current LongRun performance level (expressed as a percentile), and the current LongRun flags. -v Be more verbose. -f flag Set a LongRun mode flag. Currently, the two supported flags are performance and economy. This controls whether the processor is in "performance mode" or "economy mode". -s low high Set the current LongRun performance window as a percentile range. The low number cannot be greater than the high number. The minimum and maximum performance values accepted by the CPU are 0 and 100, respectively. ENVIRONMENT
No environment variables are used. FILES
This program requires that the Linux CPUID and MSR devices be compiled into the kernel (or loaded as kernel modules), that the CPUID character device be readable, and that the MSR character device be both readable and writable. SEE ALSO
acpid(8), apmd(8), hdparm(8) AUTHOR
Daniel Quinlan <quinlan@transmeta.com> February 14, 2001 LONGRUN(1)