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. 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
3. 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
4. UNIX for Dummies Questions & Answers
Hi all, I've searched the web for a long time trying to figure out how to merge columns from multiple files.
I know paste will append columns like so:
paste file1 file2 file3 file4 file5 ...
But this becomes inconvenient when you want to append a large number of files into a single file.
... (2 Replies)
Discussion started by: torchij
5. 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
6. Shell Programming and Scripting
I have an input file of this kind
The logic is as follows, read a row, compare column1 to the next, if there is a match, compare column4. If these two match, grab the minimum of column2 and maximum of column3 and print the output with column1,... (3 Replies)
Discussion started by: jacobs.smith
7. Shell Programming and Scripting
Hi all - I have a file like below:
This format repeats
The output should come in a single line merging the first line field with the other two rows:
A1_1 A1_z A2_2 A2_y A3_3 A3_x A4_4 A4_w
Could anyone help with some directions
... (4 Replies)
Discussion started by: deepakgang
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. Shell Programming and Scripting
Hi guz I want to merge multiple rows into a multiple columns based on the first column.
The file has symbol //
I want to break the symbool // and I nedd exactlynew column at that point
the output will be like this
please guyz help in this isssue!!!!!
merging rows into columns ... (4 Replies)
Discussion started by: bogu0001
10. UNIX for Advanced & Expert Users
I have three files, basically:
file 1 - one line header
file 2 - big data (approx 80GB)
file 3 - a one line trailer
the existing process cats these together i.e cat file 1 file 2 file 3
however... I was thinking, surely it could be more efficient to insert the header (file 1) on the... (2 Replies)
Discussion started by: miwinter