08-31-2008
Need Help Comparing two Files
I really need help on creating a script that does the following:
I have one file (File 1) with lines in the following format:
Name.maf score1 score2
I have a second file (File 2) with lines in the following format:
label start end Name
What I need to do is compare File 1 and File 2. When the Name matches, then I need to add the "label, "start" and "end" column's value of File 2 to the 2nd, third and fourth column of File 1 to get
Output
Name.maf label start end score1 score2
The trick here too is that what needs to match is only the Name, not the entire Name.maf. e.g. hello.maf and hello would be Name matches.
Any help would be very much appreciated! Thanks!
Last edited by awknerd; 08-31-2008 at 07:50 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi
I need to compare shadow file sizes with their real file counterparts. If the shadow file size differs form the realfile size then it must send a mail. My problem is that our system has over 1600 shadowfiles in different directories, with different names. the only consistancy is the .sh file... (4 Replies)
Discussion started by: terrym
4 Replies
2. Shell Programming and Scripting
I have a file called X, which contains the following:
10
100
200
300
I then have file Y, which containts the following:
10
200
500
800
I want to write a script that will compare the contents of Y with the contents of X and ONLY return values in Y that does not exist in X (output... (5 Replies)
Discussion started by: soliberus
5 Replies
3. Shell Programming and Scripting
So I have two files:
File1
pictures.txt 1.1 1.3
dance.txt 1.2 1.4
treehouse.txt 1.3 1.5
File2
pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244
dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2 ref4948 1.1
treehouse.txt 1.6 ref8573 1.5 ref3284 1.4 ref5838... (24 Replies)
Discussion started by: linuxkid
24 Replies
4. UNIX for Dummies Questions & Answers
HI ALL,
i have two files each with three columns.
i need to compare the row in file 1 is present in file 2 using FOR loop.
Please Help.
Thanks in Advance
Regards,
Arun Manas (1 Reply)
Discussion started by: arunmanas
1 Replies
5. Shell Programming and Scripting
I've two files with data like below:
file1.txt:
AAA,Apples,123
BBB,Bananas,124
CCC,Carrot,125
file2.txt:
Store1|AAA|123|11
Store2|BBB|124|23
Store3|CCC|125|57
Store4|DDD|126|38
So,the field separator in file1.txt is a comma and in file2.txt,it is |
Now,the output should be... (2 Replies)
Discussion started by: asyed
2 Replies
6. UNIX for Advanced & Expert Users
Hi Guys ,
we have one directory ...in that directory all files will be set on each day..
files must have header ,contents ,footer..
i wants to compare the header,contents,footer ..if its same means display an error message as 'files contents same' (7 Replies)
Discussion started by: Venkatesh1
7 Replies
7. Shell Programming and Scripting
Hi all
I have to compare two file this time
one is
P11223
x1124
x1145
t5678
e3456
z2345
another file
P11223 x s (2 Replies)
Discussion started by: manigrover
2 Replies
8. Shell Programming and Scripting
Hi Friends,
I have file1.txt
file2.txt
I tried using the diff and comm but not getting the expected output..
I want where exactly the miss match occurs. probably the field.
Sourcevalue|Targetvalue|Linenumber|field
29123975|2923975|3|1
Please help. (6 Replies)
Discussion started by: i150371485
6 Replies
9. Shell Programming and Scripting
I hope I can explain this correctly. I am using Bash-4.2 for my shell.
I have a group of file names held in an array. I want to compare the names in this array against the names of files currently present in a directory. If the file does not exist in the directory, that is not a problem.... (5 Replies)
Discussion started by: BudMan
5 Replies
10. UNIX for Beginners Questions & Answers
I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ?
Source File
*************
# file: /local/test_1
# owner: own
#... (4 Replies)
Discussion started by: sarathy_a35
4 Replies
NET(5) File Formats Manual NET(5)
NAME
net - format of .net files read/written by Magic's netlist editor
DESCRIPTION
Netlist files are read and written by Magic's netlist editor in a very simple ASCII format. The first line contains the characters
`` Netlist File'' (the leading blank is important). After that comes a blank line and then the descriptions of one or more nets. Each
net contains one or more lines, where each line contains a single terminal name. The nets are separated by blank lines. Any line that is
blank or whose first character is blank is considered to be a separator line and the rest of its contents are ignored.
Each terminal name is a path, much like a file path name in Unix. It consists of one or more fields separated by slashes. The last field
in the path is the name of a label in a cell. The other fields (if any), are cell instance identifiers that form a path from the edit cell
down to the label. The first instance identifier must name a subcell of the edit cell, the second must be a subcell of the first, and so
on.
Instance identifiers are unique within their parent cells, so a terminal path selects a unique cell to contain the label. However, the
same label may appear multiple times within its cell. When this occurs, Magic assumes that the identical labels identify electrically
equivalent terminals; it will choose the closest of them when routing to that terminal. Further, after connecting to one of these termi-
nals Magic may take advantage of the internal wiring connecting them together and route through a cell to complete the net's wiring.
An example netlist file follows below. It contains three distinct nets.
----------------------------------------
Netlist File
alu/bit_1/cout
alu/bit_2/cin
regcell[21,2]/output
latch[2]/input
This line starts with a blank, so it's a separator.
opcode_pla/out6
shifter/drivers/shift2
----------------------------------------
SEE ALSO
magic(1)
4th Berkeley Distribution NET(5)