---------- Post updated at 13:52 ---------- Previous update was at 13:30 ----------
Anyhow, try
Code:
awk '!MIN[$6] {MIN[$6] = 1E100}
FNR==NR {CNT[$6]++
if ($9 < MIN[$6]) {MIN[$6]=$9; F3[$6]=$3; F7[$6]=$7}
next
}
FNR==1 {print $0, " no of SNPs Top rs ID Top categ Top P"
next
}
{$1=$1}
{print $0, CNT[$1], F3[$1], F7[$1], MIN[$1]}
' file2 OFS="\t" file1
Name test1 status P no of SNPs Top rs ID Top categ Top P
Gene1 0.00236753 1 1.00E-01 6 SNP3 MEDIUM 1.70E-01
Gene2 0.134187 2 2.00E-01 2 SNP7 HIGH 6.34E-01
Gene3 0.000608716 2 3.00E-01 1 SNP9 HIGH 2.94E-01
Gene4 0.0016234 1 4.00E-01 4 SNP12 HIGH 1.55E-01
Gene5 0.000665868 2 5.00E-01 5 SNP15 LOW 2.09E-02
---------- Post updated at 14:01 ---------- Previous update was at 13:52 ----------
This is running into problems as the space in "VERY HIGH" shifts the field count... so the field separator needs to be <TAB>, and both files should comply...replace ' file2 OFS="\t" file1
with ' FS="\t" OFS="\t" file2 file1.
hi guys i need to extract information from log files generated by an application.
log file has the following lines for each process..
----------------------------------------------
Fri Aug 03 12:06:43 WST 2007 INFO: Running project PROJECT1
Fri Aug 03 12:06:43 WST 2007 INFO: Source Files... (7 Replies)
Anyone have a better idea to automate extraction of info like ...
"uname"
"ifconfig"
"ps efl"
"netstat -ao"
etc.
from several hundred aix, solaris, red hat boxes? without logging into each box and manually performing these tasks and dumping them to individual files?
thanks for any input (1 Reply)
I am not an expert in awk, SED, etc... but I really hope there is a way to do this, because I don't want to have to right a program. I am using C shell.
FILE 1 FILE 2
H0000000 H0000000
MA1 MA1
CA1DDDDDD CA1AAAAAA
MA2 ... (2 Replies)
I have this code
awk 'NR==FNR{a=$1;next} a' file1 file2
which does what I need it to do, but for only two files. I want to make it so that I can have multiple files (for example 30) and the code will return only the items that are in every single one of those files and ignore the ones... (7 Replies)
I have two files : Alpha and Beta.
The files are as follows (without arrow marks.)
Alpha:
A 1
D 90
G 11
B 24
C 15
Beta:
B 24
C 0 <--
G 11
D 20 <--
A 4 <--
E 777 <--
Expected output of the script :
Alpha: (2 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Assume we have two files - FileA and FileB. Content of files are as shown below :
FileA:1001,value1,value4,value8,value9
1002,value4,value32,value46,value33
1503,value5,value45,value68,value53
1605,value4,value67,value56,value57
1073,value5,value45,value68,value53... (3 Replies)
PHAR.EXTRACTTO(3) 1 PHAR.EXTRACTTO(3)Phar::extractTo - Extract the contents of a phar archive to a directory
SYNOPSIS
public bool Phar::extractTo (string $pathto, [string|array $files], [bool $overwrite = false])
DESCRIPTION
Note
This method requires the php.ini setting phar.readonly to be set to 0 in order to work for Phar objects. Otherwise, a PharException
will be thrown.
Extract all files within a phar archive to disk. Extracted files and directories preserve permissions as stored in the archive. The
optional parameters allow optional control over which files are extracted, and whether existing files on disk can be overwritten. The sec-
ond parameter files can be either the name of a file or directory to extract, or an array of names of files and directories to extract. By
default, this method will not overwrite existing files, the third parameter can be set to true to enable overwriting of files. This method
is similar to ZipArchive.extractTo(3).
PARAMETERS
o $pathto
- Path within an archive to the file to delete.
o $files
- The name of a file or directory to extract, or an array of files/directories to extract
o $overwrite
- Set to TRUE to enable overwriting existing files
RETURN VALUES
returns TRUE on success, but it is better to check for thrown exception, and assume success if none is thrown.
ERRORS /EXCEPTIONS
Throws PharException if errors occur while flushing changes to disk.
EXAMPLES
Example #1
A Phar.extractTo(3) example
<?php
try {
$phar = new Phar('myphar.phar');
$phar->extractTo('/full/path'); // extract all files
$phar->extractTo('/another/path', 'file.txt'); // extract only file.txt
$phar->extractTo('/this/path',
array('file1.txt', 'file2.txt')); // extract 2 files only
$phar->extractTo('/third/path', null, true); // extract all files, and overwrite
} catch (Exception $e) {
// handle errors
}
?>
SEE ALSO PharData.extractTo(3).
PHP Documentation Group PHAR.EXTRACTTO(3)