|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merging two file based on comparison of first columns
Post 302921316 by manojmalhotra on Thursday 16th of October 2014 10:36:00 AM
10-16-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi
i need to select a few columns of two txt files and write it to a new file. there is one common field for both of these files.
plz help me in this
thanks in advance (4 Replies)
Discussion started by: kolvi
4 Replies
2. Shell Programming and Scripting
Hi,
I want to select columns from multiple files and combine them in one file. The files are simulation-data-files with 23 columns each and about 50 rows. I now use:
cut -f 11 Sweep?wing-30?scale=0.?0?fan2?.txt | pr -3 | awk '{printf("\n%s\t%s\t%s",$1,$2,$3)}' > ../Data_Processed/output.txtI... (1 Reply)
Discussion started by: isgoed
1 Replies
3. Shell Programming and Scripting
Hi Guys. I have tried the commands sort and join. But I couldn't able to to find the command for joining in a single line based on keys.My example inputs and outputs are like the following.
Help would be appreciated.:D
Input file
a1tabXXXXXXX
a2tabXXXXXXX
a6tabYYYYYYYYY
a71tabXXXXXXX... (7 Replies)
Discussion started by: repinementer
7 Replies
4. Shell Programming and Scripting
Okay, first of all, thanks to everyone who's helped me out before... I appreciate the opportunity to learn.
I have two iTunes XML files, and I simply want to compare the contents, then merge. Theoretically, this will allow me to merge two libraries, keeping playlists intact (depending on iTunes'... (4 Replies)
Discussion started by: karlp
4 Replies
5. UNIX for Dummies Questions & Answers
Hi there,
I'm trying to merge two files and make a third file.
However, two of the columns need to match exactly in both files AND I want everything from both files in the output if the two columns match in that row.
First file looks like this:
chr1 10001980 T A
Second... (12 Replies)
Discussion started by: infiniteabyss
12 Replies
6. Shell Programming and Scripting
I have two files.
FileA.txt
30910 rs7468327
36587 rs10814410
91857 rs9408752
105797 rs1133715
146659 rs2262038
152695 rs2810979
181843 rs3008128
182129 rs3008131
192118 rs3008170
FileB.txt
30910 1.9415219673 0
36431 1.3351312477 0.0107191428
36587 1.3169171182... (2 Replies)
Discussion started by: genehunter
2 Replies
7. Shell Programming and Scripting
Hi
I have 2 files
1.del
----
1,2,3,4,5
1,2,3,4,4
1,1,1,1,2
2.del
----
1,2,3,4,5
1,
1,2,3,4,4
1,1,1,1,2
I need to compare the above two files in unix, as in the output should only tell the difference in contents as I should get only the line
1 ( from 2.del) , rest all lines are... (4 Replies)
Discussion started by: Ethen561
4 Replies
8. Shell Programming and Scripting
Hi,
I have following input in the file in which i want to club the entries based on $1. Also $11 is equal to $13 of other record(where $13 must be on higher side for any $1) then sum all other fields except $11 & $13. Final output required is as follows:
INPUTFILE:
... (11 Replies)
Discussion started by: siramitsharma
11 Replies
9. Shell Programming and Scripting
Respected Members.
Hello.
This is my first post in the forum. I will try to follow all the rules as prescribed by the forum. In case of non-compliance, I request you to kindly give me some more time to understand and abide by them.
I am working on two files. I wish to merge the two files... (1 Reply)
Discussion started by: manojmalhotra
1 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I am facing issues while accomplishing below task.
We have two files Test1.txt and Test2.txt. We have to match 1st column of Test1.txt file with 2nd column of Test2.txt and then merge 2nd file with the 1st file. In the output we should select column 1 and 2 from the 1st file and column 1... (5 Replies)
Discussion started by: Prathmesh
5 Replies
LEARN ABOUT REDHAT
alcc
ALCC(1) aMule utilities ALCC(1) NAME
alcc - text based eD2k links calculator for aMule SYNOPSIS
alcc [-p] [-v] <inputfiles_list> alcc [-h] DESCRIPTION
Compute the eD2k links of all the input files given in the <inputfiles_list> (There can be one or more files). [ -p, --parthashes ] Compute and add part hashes to the computed eD2k links. [ -h, --help ] Prints a short usage description. [ -v, --verbose ] Be verbose - show also calculation steps. REPORTING BUGS
Please report bugs either on our forum (http://forum.amule.org/), or in our bugtracker (http://bugs.amule.org/). Please do not report bugs in e-mail, neither to our mailing list nor directly to any team member. COPYRIGHT
aMule and all of its related utilities are distributed under the GNU General Public License. SEE ALSO
alc(1), amuled(1), amulecmd(1), amuleweb(1), cas(1), ed2k(1), wxcas(1), xas(1) AUTHOR
This manpage was written by Vollstrecker <amule@vollstreckernet.de> aMule eD2k links calculator November 2011 ALCC(1)