06-02-2008
compare columns from seven files and print the output
Hi guys,
I need some help to come out with a solution . I have seven such files but I am showing only three for convenience.
filea
a5 20
a8 16
fileb
a3 42
a7 14
filec
a5 23
a3 07
The output file shoud contain the data in table form showing first field of each file with their second field(score) in each file.
ID filea fileb filec
a5 20 00 23
a8 16 00 00
a3 00 42 07
a7 00 14 00
Your help is highly appretiated.
-Smriti
Last edited by smriti_shridhar; 06-03-2008 at 01:33 AM..
Reason: formating not proper
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have two tab separated files;
file1:
S.No ddi fi cu o/l t+ t-
1 0.5 0.6 o 0.1 0.2
2 0.2 0.3 l 0.3 0.4
3 0.5 0.8 l 0.1 0.6
... (5 Replies)
Discussion started by: vasanth.vadalur
5 Replies
2. Shell Programming and Scripting
one file
. . importing table employee 119
. . importing table jobs 1
2nd file
. . importing table employee 120
. . importing table jobs 1
and would like... (2 Replies)
Discussion started by: jhonnyrip
2 Replies
3. Shell Programming and Scripting
hi! i researched about comparing two columns here and got an answer. but after examining my two files, i found out that the first columns of the two files are not unique with each other. all i want to compare is the 2nd and 3rd column.
FILE 1:
ABS 456 315
EBS 923 163
JYQ3 654 237
FILE 2:... (1 Reply)
Discussion started by: engr.jay
1 Replies
4. Shell Programming and Scripting
File 1 has 16 columns so does File 2
I want to remove all records from File 2 that column 1 and column 16 match between file 1 and file 2
delimter of files is ~ (10 Replies)
Discussion started by: sigh2010
10 Replies
5. Shell Programming and Scripting
Hello,
I have not been able to find what I'm looking for via searching the forum. I could use some help with an awk script or one-liner to solve this simple problem.
I have two files. If $1 and $2 from file1 match $1 and $2 from file2, print the whole line from file2.
Example file1
... (2 Replies)
Discussion started by: jm4smtddd
2 Replies
6. Shell Programming and Scripting
Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3.
FILE1
1466 55.27433 14.72050 -2.52E+03 3.00E-01 1.05E+04 2.57E+04
1467 55.27433... (1 Reply)
Discussion started by: jm4smtddd
1 Replies
7. Shell Programming and Scripting
Hello,
I have two files which are of the following format
File 1 which has two columns
Protein_ID Substitution
NP_997239 T53R
NP_060668 V267M
NP_058515 P856A
NP_001206 T55M
NP_006601 D371Y ... (2 Replies)
Discussion started by: nans
2 Replies
8. Shell Programming and Scripting
Hi,
I have multiple files that each contain one column of strings:
File1:
123abc
456def
789ghi
File2:
123abc
456def
891jkl
File3:
234mno
123abc
456def
In total I have 25 of these type of file. (5 Replies)
Discussion started by: owwow14
5 Replies
9. Shell Programming and Scripting
Hi,
I want to compare two columns from file1 with another two column of file2 and print matched and unmatched column like this
File1
1 rs1 abc
3 rs4 xyz
1 rs3 stu
File2
1 kkk rs1 AA 10
1 aaa rs2 DD 20
1 ccc ... (2 Replies)
Discussion started by: justinjj
2 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
i am trying to compare two files in Centos 6.
F1: /tmp/d21
NAME="xvda" TYPE="disk" SIZE="40G" OWNER="root" GROUP="disk" MODE="brw-rw----" MOUNTPOINT=""
NAME="xvda1" TYPE="part" SIZE="500M" OWNER="root" GROUP="disk" MODE="brw-rw----" MOUNTPOINT="/boot"
NAME="xvda2" TYPE="part"... (2 Replies)
Discussion started by: balu1234
2 Replies
tic(1) General Commands Manual tic(1)
Name
tic - terminfo compiler
Syntax
tic [ -v[n] ] [ file ... ]
Description
The command translates files from the source format into the compiled format. The results are placed in the directory The compiled format
is necessary for use with the library routines described in The file argument contains one or more terminal descriptions in source format.
If no file argument is present, the standard input is read.
The command compiles all terminfo descriptions in the given files. Each description in the file describes the capabilities of a particular
terminal. When a use=entry_name field is discovered, duplicates the capabilities in entry_name for the current entry, with the exception
of the capabilities that are explicitly defined in the current entry.
If the environment variable TERMINFO is set, the results are placed there instead of in The variable TERMINFO must be a directory pathname.
The compiled results are placed in subdirectories of the directory specified by the TERMINFO environment variable.
-v[n] Causes to output trace information showing its progress (verbose mode). The optional integer n is a number from 1 to 10, inclu-
sive, indicating the desired level of information. If n is greater than 1, the level of detail is increased. If n is omitted, the
default is 1.
Restrictions
Total compiled entries cannot exceed 4096 bytes.
The entry_name field cannot exceed 128 bytes.
When an entry, for example entry_name_1, contains a use=entry_name_2 field, any canceled capabilities in entry_name_2 must also appear in
entry_name_1 before use= for these capabilities to be canceled in entry_name_1.
Files
Compiled terminal capability data base
See Also
intro(3cur), terminfo(5)
Guide to X/Open curses Screen Handling
tic(1)