merge two text files of different size on common index Post: 302518646

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr

2. Shell Programming and Scripting

How to remove common file names from text files

I'm running on freebsd -- with a default shell of csh. I have two files named A and B. Each line of each file contains a file name. How can I write a script that removes all the file names in file B from A. I tried to use perl to create a huge regular expression with "|" separating the file...

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

4. UNIX for Dummies Questions & Answers

Merge two files with common IDs but unequal number of rows

Hi, I have two files that I would like to merge and think that there should be a solution using awk. The files look something like this: file 1 IDX1 IDY1 IDX2 IDY2 IDX3 IDY3 file 2 IDY1 dataA data1 IDY2 dataB data2 IDY3 dataC data3 Desired output IDX1 IDY1 dataA data1 IDX2 ...

5. Shell Programming and Scripting

script to merge two files on an index

I have a need to merge two files on the value of an index column. input file 1 id filePath MDL_NUMBER 1 MFCD00008104.mol MFCD00008104 2 MFCD00012849.mol MFCD00012849 3 MFCD00037597.mol MFCD00037597 4 MFCD00064558.mol MFCD00064558 5 MFCD00064559.mol MFCD00064559 input file 2 ...

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

7. Shell Programming and Scripting

Find matched patterns in a column of 2 files with different size and merge them

Hi, i have input files like below:- input1 Name Seq_ID NewID Scores MT1 A0QZX3 1.65 277.4 IVO A0QZX3 1.65 244.5 HPO A0QZX3 1.65 240.5 RgP A0Q3PP 5.32 241.0 GX1 LPSZ3S 96.1 216.9 MEL LPSS3X 4.23 204.1 LDD LPSS3X 4.23 100.2 input2 Fac AddName NewID ...

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

9. UNIX for Dummies Questions & Answers

Merge selective columns from files based on common key

Hi, I am trying to selectively merge two files based on keys reported in the 1st column. File1: #file1-header1 file1-header2 111 qwe rtz uio 198 asd fgh jkl 165 yxc 789 poi uzt rew 89 lkj File2: #file2-header2 file2-header2 165 ghz nko2 ...

10. Shell Programming and Scripting

Merge multiple tab delimited files with index checking

Hello, I have 40 data files where the first three columns are the same (in theory) and the 4th column is different. Here is an example of three files, file 2: A_f0_r179_pred.txt Id Group Name E0 1 V N(,)'1 0.2904 2 V N(,)'2 0.3180 3 V N(,)'3 0.3277 4 V N(,)'4 0.3675 5 V N(,)'5 0.3456 ...

LEARN ABOUT DEBIAN

shanty

SHANTY(1)							      Shanty								 SHANTY(1)

NAME

       Shanty - Makes a PostScript file from an image and some text.

SYNOPSIS

       shanty -i image_file [-t text_file] [-o output_file] [-s paper_size] [-d density] [-m margin] [-b background_color] [-x padding] [-n title]
       [-l orientation] [-rtl] [-btt] [-f font_name] [-altgd]

DESCRIPTION

       Shanty takes a text file and an image (PNG or JPG) and creates a PostScript file where one pixel in the image becomes one character in  the
       PostScript.

OPTIONS

       -i, -image
		 Name of the image to load in. JPG and PNG images are supported. This is the only compulsory field.

       -t, -text Name of the text file to load in, if omitted STDIN is used.

       -o, -output
		 Name of the PostScript file to produce, if omitted STDOUT is used.

       -s, -size Size  of  the	paper  to  work  with.	This  field  should be one of: "a0", "a2", "a3", "a4", "a5", "a6", "letter", "broadsheet",
		 "ledger", "tabloid", "legal", "executive" and "36x36". Default is "a4".

       -d, -density
		 Density of the text. Higher numbers are more dense, default is 1.4.

       -m, -margin
		 The margins of the page in cm. Default is 1.

       -b, -background
		 The colour of a backing rectangle to place behind the text. Colours are specified as "R,G,B" with each value between 0  and  255.
		 "off" means no backing colour. Default is "off".

       -x, -p, -padding
		 Density of the text. Higher numbers are more dense, default is 1.4.

       -n, -title
		 The title of the output to write as meta-data in the PostScript file. Default is "Shanty output".

       -l, -orientation
		 The orientation of the paper, can be "portrait", "landscape" or "auto". Default is "auto".

       -rtl	 Switch to right-to-left text.

       -btt	 Switch to bottom-to-top text.

       -f, -font Specify font. The font name specified must be visible to the not just make a font magically appear. Default is "Courier-Bold".

       -altgd	 If you have problems loading the GD library, try this switch.

HOMEPAGE

       <http://www.codebunny.org/coding/shanty/>

AUTHOR

       Duncan Martin <duncan@codebunny.org>

ACKNOWLEDGEMENTS

       Many thanks to DFB <http://www.cs.nott.ac.uk/~dfb/> and contributors to comp.lang.postscript.

Duncan Martin							  6 October 2006							 SHANTY(1)