Merge with common column Post: 302728669

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge based on common, awk help

All, $ cat x.txt z 11 az x 12 ax y 13 ay $ cat y.txt ay TT ax NN Output required: y 13 ay TT x 12 ax NN

2. Shell Programming and Scripting

merge rows based on a common column

Hi guys, Please guide me if you have a solution to this problem. I have tried paste -s but it's not giving the desired output. I have a file with the following content- A123 box1 B345 bat2 C431 my_id A123 service C431 box1 A123 my_id I need two different outputs- OUTPUT1 A123...

3. Shell Programming and Scripting

"Join" or "Merge" more than 2 files into single output based on common key (column)

Hi All, I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations: 1. I am restrained to 2 input files only. 2. Only the "matched" fields are written out to the "matched" output file and...

4. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

I have 100 data files labelled 250.1.txt through 250.100.txt. The second column of the data files partially match (there is about %90 overlap). Each data file has 4 columns. I want the merge all these text files by the matching values in the second column. In the output, the first column should...

5. UNIX for Dummies Questions & Answers

Merge rows with common column

Dear all I have big file with two columns A_AA960715 GO:0006952 A_AA960715 GO:0008152 A_AA960715 GO:0016491 A_AA960715 GO:0007165 A_AA960715 GO:0005618 A_AA960716 GO:0006952 A_AA960716 GO:0005618 A_AA960716...

6. Shell Programming and Scripting

file merge based on common columns

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...

7. Shell Programming and Scripting

Count and merge using common column

I have the following records from multiple files. 415 A G 415 A G 415 A T 415 A . 415 A . 421 G A 421 G A,C 421 G A 421 G A 421 G A,C 421 G . 427 A C 427 A ...

8. Shell Programming and Scripting

Merge files based on both common and uncommon rows

Hi, I have two files A (2190 rows) and file B (1100 rows). I want to merge the contents of two files based on common field, also I need the unmatched rows from file A file A: ABC XYZ PQR file B: >LMN|chr1:11000-12456: >ABC|chr15:176578-187678: >PQR|chr3:14567-15866: output...

9. Shell Programming and Scripting

Seperated by columns, merge in a file, sort them on common column

Hi All, I have 4 files in below format. I took them as an example. File 1: Cut from position 1-4 then 6-7 then 8-14 then rest left and make them as columns in one new file. Inserting character H to the initial of all line like HCTOT. CTOT 456787897 Low fever CTOR 556712345 High fever...

10. Shell Programming and Scripting

Merge multiple files with common header

Hi all, Say i have multiple files x1 x2 x3 x4, all with common header (date, time, year, age),, How can I merge them to one singe file "X" in shell scripting Thanks for your suggestions.

LEARN ABOUT DEBIAN

filter-mouse

filter-mouse(7) 							GGI							   filter-mouse(7)

NAME

       filter-mouse - Generic mouse event translator

SYNOPSIS

       filter-mouse: [<file>]

DESCRIPTION

       This filter translates mouse events according to a set of translation rules.

OPTIONS

       file   The  name  of  the configuration file. If none given, the filter will first look for the file filter/mouse in the user GGI directory
	      ($HOME/.ggi/ on UNIX), then in the base GGI directory if not found.

CONFIGURATION

       The translation rules are specified through a simple text file. The following example gives a good idea of the  mouse  filter  usage.  A  #
       marks the rest of the line as a comment.

EXAMPLE

       A set of mouse translation rules:

       # Syntax is:
       # incoming-type [type-specifics] TO outgoing type [type-specifics]

       #
       # Simulated mouse buttons on the keyboard
       #
       #KEY modmask modvalue button label  symbol TO BUT buttonnumber
       KEY 0x0004  0x0004   0xffff 0x000d 0xffff TO BUT 1	     # Alt-Enter
       KEY 0x0004  0x0004   0xffff 0x0020 0xffff TO BUT 2	     # Alt-Space
       KEY 0x0004  0x0004   0xffff 0x0008 0xffff TO BUT 3	     # Alt-BackSpace

       #
       # Keyboard-Mouse on the Cursors
       #
       #KEY modmask modval button label  symbol TO REL axis value
       KEY 0x0004  0x0004 0xffff 0xe034 0xffff TO REL X    -5	     # Alt-Left
       KEY 0x0004  0x0004 0xffff 0xe035 0xffff TO REL X     5	     # Alt-Right
       KEY 0x0004  0x0004 0xffff 0xe032 0xffff TO REL Y    -5	     # Alt-Up
       KEY 0x0004  0x0004 0xffff 0xe033 0xffff TO REL Y     5	     # Alt-Down

       #
       # Keyboard mouse on the Numpad
       #
       KEY 0x0004 0x0004 0xffff 0xe231 0xffff TO REL X -5    # Alt-Num1
       KEY 0x0004 0x0004 0xffff 0xe231 0xffff TO REL Y	5    # Alt-Num1
       KEY 0x0004 0x0004 0xffff 0xe232 0xffff TO REL Y	5    # Alt-Num2
       KEY 0x0004 0x0004 0xffff 0xe233 0xffff TO REL X	5    # Alt-Num3
       KEY 0x0004 0x0004 0xffff 0xe233 0xffff TO REL Y	5    # Alt-Num3
       KEY 0x0004 0x0004 0xffff 0xe234 0xffff TO REL X -5    # Alt-Num4
       KEY 0x0004 0x0004 0xffff 0xe235 0xffff TO BUT 1		     # Alt-Num5 - Button
       KEY 0x0004 0x0004 0xffff 0xe236 0xffff TO REL X	5    # Alt-Num6
       KEY 0x0004 0x0004 0xffff 0xe237 0xffff TO REL X -5    # Alt-Num7
       KEY 0x0004 0x0004 0xffff 0xe237 0xffff TO REL Y -5    # Alt-Num7
       KEY 0x0004 0x0004 0xffff 0xe238 0xffff TO REL Y -5    # Alt-Num8
       KEY 0x0004 0x0004 0xffff 0xe239 0xffff TO REL X	5    # Alt-Num9
       KEY 0x0004 0x0004 0xffff 0xe239 0xffff TO REL Y -5    # Alt-Num9

       #
       # Home the cursor ...
       #
       KEY 0x0004 0x0004 0xffff 0xE038 0xffff TO ABS X 0     # Alt-Home
       KEY 0x0004 0x0004 0xffff 0xE038 0xffff TO ABS Y 0     # Alt-Home

       #
       # Invert mouse axis
       #
       #REL modmsk modval axis TO REL axis multiplier
       REL 0x0004 0x0004 X    TO REL Y	  -1
       REL 0x0004 0x0004 Y    TO REL X	  -1

       #
       # Accelerate mouse
       #
       #			     multiplier treshold higher-speed
       REL 0x0004 0x0004 X TO REL X 1	       5	4
       REL 0x0004 0x0004 Y TO REL Y 1	       5	4

       #
       #
       # Invert mouse buttons
       BUT 0x0004 0x0004 1 TO BUT 2
       BUT 0x0004 0x0004 2 TO BUT 1

libgii-1.0.x							    2003-08-11							   filter-mouse(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge based on common, awk help

Discussion started by: jkl_jkl

2. Shell Programming and Scripting

merge rows based on a common column

Discussion started by: smriti_shridhar

3. Shell Programming and Scripting

"Join" or "Merge" more than 2 files into single output based on common key (column)

Discussion started by: Katabatic

4. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

Discussion started by: evelibertine