10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Join and merge multiple files with duplicate key and fill void columns
I have many files that I want to merge:
file2.csv: (5 Replies)
Discussion started by: yjacknewton
2. UNIX for Beginners Questions & Answers
I will like to merge several files using 'cat', but I observe the output is not consistent. the merge begins at the last line of the first file.
cat file1.txt file2.txt > file3.txt
cccc... (13 Replies)
Discussion started by: geomarine
3. Shell Programming and Scripting
Hello and Good day
I have a lot of files with same number of rows and columns.$2 and $3 are the same in all files .
I need to merge $2,$3,$6 from first file and $6 from another files.
$1 $2 $3 $4 $5 $6... (8 Replies)
Discussion started by: ali.seifaddini
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
Hello, I have two files that have this format:
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
I would like to merge these two files such that the final file looks like... (5 Replies)
Discussion started by: kayak
6. UNIX for Dummies Questions & Answers
I'm looking for a way to merge multiple columns (from one file) into a single column in an output file.
The file I have looks somewhat like this:
@HWI-ST212 1:N:0 AGTCCTACCGGGAGT + @@@DDDDDHHHHHII
@HWI-ST212 1:N:0 CGTTTAAAAATTTCT + @;@B;DDDDH?:F;F... (4 Replies)
Discussion started by: Vnguyen
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hi may i ask how to accomplish this task:
I have 2 files which has multiple columns
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
9. UNIX for Dummies Questions & Answers
Being new to Unix i have a problem. I have 2 files:
118,1,BFGL-NGS-109695,3610326,0,18,1,0.556,0.389,0.056,0.25,0.8183... (2 Replies)
Discussion started by: samwilkinson
10. Shell Programming and Scripting
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
(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