Merge Two Tables with duplicates in first table

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Filtering duplicates based on lookup table and rules

please help solving the following. I have access to redhat linux cluster having 32gigs of ram. I have duplicate ids for variable names, in the file 1,2 are duplicates;3,4 and 5 are duplicates;6 and 7 are duplicates. My objective is to use only the first occurrence of these duplicates. Lookup...

2. UNIX for Dummies Questions & Answers

How to merge two tables based on a matched column?

Hi, Please excuse me , i have searched unix forum, i am unable to find what i expect , my query is , i have 2 files of same structure and having 1 similar field/column , i need to merge 2 tables/files based on the one matched field/column (that is field 1), file 1:...

3. Shell Programming and Scripting

Help with merge and remove duplicates

Hi all, I need some help to remove duplicates from a file before merging. I have got 2 files: file1 has data in format 4300 23456 4301 2357 the 4 byte values on the right hand side is uniq, and are not repeated anywhere in the file file 2 has data in same format but is not in...

4. Shell Programming and Scripting

Merge files without duplicates

Hi all, In a directory of many files, I need to merge only files which do not have identical lines and also the resulatant merge file should not be more than 50000 lines. Basically I need to cover up all text files in that directory and turn them to Merge files.txt with 50000 lines each ...

5. Shell Programming and Scripting

Find duplicates in column 1 and merge their lines (awk?)

Hi, I have a file (sorted by sort) with 8 tab delimited columns. The first column contains duplicated fields and I need to merge all these identical lines. My input file: comp100002 aaa bbb ccc ddd eee fff ggg comp100003 aba aba aba aba aba aba aba comp100003 fff fff fff fff fff fff fff...

6. Shell Programming and Scripting

Merge multiple tables into big matrix

Hi all, I have a complex (beyond my biological expertise) problem at hand. I need to merge multiple files into 1 big matrix. Please help me with some code. Inp1 Ang_0 chr1 98 T A Ang_0 chr1 352 G A Ang_0 chr1 425 C T Ang_0 chr2 ...

7. Shell Programming and Scripting

merge multiple tables with perl

Hi everyone, I once again got stuck with merging tables and was wondering if someone could help me out on that problem. I have a number of tab delimited tables which I need to merge into one big one. All tables have the same header but a different number of rows (this could be changed if...

8. Shell Programming and Scripting

squeeze duplicates from a table

I have files with an x amounts of rows with each row having 2 columns seperated by delimiter "|" . File contains following records for example. 15|69 15|70 15|71 15|72 15|73 15|74 16|2 16|3 16|4 16|5 16|6 16|7 16|8 16|9 16|10 16|11 16|12

LEARN ABOUT DEBIAN

rep

REP(1)																	    REP(1)

NAME

       rep - Read, Eval, Print Interpreter

SYNOPSIS

       rep  [	FILE  ] [  --batch  ] [  --interp  ] [	-f, --call FUNCTION  ] [  -l, --load FUNCTION  ] [  -s, --scheme FILE  ] [  --version  ] [
       --no-rc	] [  -q, --quit  ]

DESCRIPTION

       rep `librep' is a dialect of Lisp, designed to be used both as an extension language for applications and as a general purpose  programming
       language.  It was originally written to be mostly-compatible with Emacs Lisp, but has subsequently diverged markedly. Its aim is to combine
       the best features of Scheme and Common Lisp and provide an environment that is comfortable for implementing both small and large scale sys-
       tems. It tries to be a "pragmatic" programming language.

OPTIONS

       FILE   load the Lisp file FILE (from the cwd if possible, implies --batch mode)

       --batch
	      Batch mode: process options and exit.

       --interp
	      Interpreted mode: don't load compile Lisp files.

       -f FUNCTION --call FUNCTION
	      Call the Lisp function FUNCTION.

       -l FILE --load FILE
	      Load the file of Lisp forms called FILE.

       -s FILE --scheme FILE
	      Load the file of Scheme forms called FILE (implies --batch mode).

       --version
	      Print version details.

       --no-rc
	      Don't load rc or site-init files.

       -q --quit
	      Terminate the interpreter process.

SEE ALSO

       The programs are documented fully by John Harper available via the Info system.

AUTHOR

       This manual page was written by Christian Marillat <marillat@debian.org> for the Debian GNU/Linux system (but may be used by others).

								   04 avril 2003							    REP(1)

Shell Programming and Scripting