|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merge files based on columns
Post 302908910 by vinus on Friday 11th of July 2014 12:03:13 PM
07-11-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm working with snmp, with a little script I'm able to obtain from a switch a list with a couple of values with this format
Port Mac
1 00:0A:0B:0C:0D:0E
....
(hundred of entries)
Now with a simple arp on a router I am able to obtain another list
00:0A:0B:0C:0D:0E... (20 Replies)
Discussion started by: CM64
20 Replies
2. Shell Programming and Scripting
Hi may i ask how to accomplish this task:
I have 2 files which has multiple columns
first file
1 a
2 b
3 c
4 d
second file
14 a 9 ....
13 b 10....
12 c 11...
11 d 12...
I want to merge the second file to first file that will looks like this
... (2 Replies)
Discussion started by: jao_madn
2 Replies
3. Shell Programming and Scripting
Hi,
I have tab limited file 1
and tab limited file 2
The output should contain common first column vales and corresponding 2nd column values; AND also unique first column value with corresponding 2nd column value of the file that contains it and 0 for the second file.
the output should... (10 Replies)
Discussion started by: polsum
10 Replies
4. Shell Programming and Scripting
I have two files
1.txt
34, ABC, 7, 8, 0.9
35, CDE, 6.5, -2, 0.01
2.txt
34, ABC, 9, 6, -1.9
35, CDE, 8.5, -2.3, 5.01
So in both files common columns are 1 and 2
so final o/p should look like
34, ABC, 7, 8, 0.9, 9, 6, -1.9
35, CDE, 6.5, -2, 0.01, 8.5, -2.3, 5.01
I tried using... (3 Replies)
Discussion started by: manas_ranjan
3 Replies
5. Shell Programming and Scripting
Hi!
I need to merge two files when col1 (x:x:x) matching and adds second column from file1.txt.
# cat 1.txt
aaa;a12
bbb;b13
ccc;c33
ddd;d55
eee;e11
# cat 2.txt
bbb;b55;34444;d55
aaa;a15;35666;a44
I try with this awk and I get succesfully first column from 1.txt:
# awk -F";"... (2 Replies)
Discussion started by: fhluque
2 Replies
6. Shell Programming and Scripting
Hello, I have two files that have this format:
file 1
86.82 0.00 86.82 43.61
86.84 0.00 86.84 43.61
86.86 0.00 86.86 43.61
86.88 0.00 86.88 43.61
file 2
86.82 0.22
86.84 0.22
86.86 0.22
86.88 0.22
I would like to merge these two files such that the final file looks like... (5 Replies)
Discussion started by: kayak
5 Replies
7. Shell Programming and Scripting
Hi All
Source1
servername1,patchid1
servername1,patchid2
servername1,patchid3
servername2,patchid1
servername2,patchid2
servername3,patchid4
servername3,patchid5
Source2
servername1,appname1
servername1,appname2
servername1,appname3
servername2,appname1
servername2,appname2... (13 Replies)
Discussion started by: mv_mv
13 Replies
8. Shell Programming and Scripting
Hi,
I have a file with 16 columns and out of these 16 columns 14 are key columns, 15 th is order column and 16th column is having information. I need to concate the 16th column based on value of 1-14th column as key in order of 15th column. Here are the example file
Input File (multiple... (3 Replies)
Discussion started by: Ravi Agrawal
3 Replies
9. Shell Programming and Scripting
Hello,
I have two tab delimited text files. Both files have the same number of rows but not necessarily the same number of columns. The column headers look like,
File 1:
f0order CVorder Name f0 RI_9 E99 E199 E299 E399 E499 E599 E699 E799 E899 E999
File 2:... (9 Replies)
Discussion started by: LMHmedchem
9 Replies
10. UNIX for Dummies Questions & Answers
Hi, I am trying to selectively merge two files based on keys reported in the 1st column.
File1:
#file1-header1
file1-header2
111 qwe rtz uio
198 asd fgh jkl
165 yxc
789 poi uzt rew
89 lkj
File2:
#file2-header2
file2-header2
165 ghz nko2 ... (2 Replies)
Discussion started by: dovah
2 Replies
LEARN ABOUT DEBIAN
netris-sample-robot
netris-sample-robot(6) Netris Sample Robot netris-sample-robot(6) NAME
netris-sample-robot - sample robot for netris SYNOPSIS
netris-sample-robot [-l] DESCRIPTION
The netris-sample-robot is a sample implementation of the robot protocol. It plays quite well but isn't too hard to beat. The robot should be started from netris with the option -r to connect or wait for another player to join. You can also let two robots play against each other in that way, if you like. OPTIONS
-l Writes some log information into the file log in the current working directory. If it can't it bails out. EXAMPLES
To start the netris-sample-robot waiting for another connection with logfile use the following line: netris -w -r 'netris-sample-robot -l' You then just have to start netris somewhere else which connects to that robot. SEE ALSO
netris(6) BUGS
One known bug of the netris-sample-robot is that it hangs quite often. This was already filed as a bugreport against the package so please refrain from doing so again. If you have an idea why this happens or know a solution how to fix it feel free to mail us. AUTHORS
Netris was written by Mark H. Weaver <mhw@netris.org>. This manual page was written by Gerfried Fuchs <alfie@debian.org> for the Debian GNU/Linux system (but may be used by others). 0.5 16 Feb 2002 netris-sample-robot(6)