where the common identifier is in column 2 (-j2) and the value i want to amend my master file with is always in column 3 (-o 1.3 2.3). I'm trying to avoid running this command over and over again, as the -o option keeps on growing (-o 1.3 1.4 2.3 --> -0 1.3 1.4 1.5 2.3 --> -o 1.3 1.4 1.5 1.6 2.3 --> -o 1.3 1.4 1.5...1.n 2.3, where n=~200)
Is there a way to use while read or something else to make the file?
Your help is much appreciated.
Thanks.
Last edited by zaxxon; 03-24-2010 at 09:33 AM..
Reason: use code tags please, ty
I am a new to Linux and try to write a script to join three multiple files.
For example, there are three files
file1
# comment
a Kevin
b Vin
c Sam
file 2
# comment
a 10
b 20
c 40
file 3
# comment
a blue
b yellow (7 Replies)
Hi,
I have a big file of 50GB size. I need copy it to a second ftp from a ftp. I am not able to do the full 50GB transfer as it timesout after some time. SO i am trying to split the file into 5gb each 10 files with the below command.
split -b 5368709120 pack.tar.gz backup.gz
After I... (2 Replies)
Hello,
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
Hi all,
I searched through the forum but i can't manage to find a solution. I need to join a set of files placed in a directory (~1600) by column, and obtain an output with first and second column common to each file, but following columns are taken from the file in the list (precisely the fourth... (10 Replies)
Hi,
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
Hi there,
I am trying to join 24 files (i showed example of 3 files below). They all have 2 columns. The first columns is common to all. The files are tab delimited eg
file 1
rs0001 100e-34
rs0003 2.8e-01
rs008 1.9e-90
file 2
rs0001 1.98e-22
rs0004 3.77e-10... (4 Replies)
Please help, I want to join multiple files based on column 1, and put the missing values as 0. Also the colname in the output should say which file the values came from.
FILE1
1 11
2 12
3 13
FILE2
2 22
3 23
4 24
FILE3
1 31
3 33
4 34
FILE1 FILE2 FILE3
1 11 0 31 (1 Reply)
Hello all,
I want to join 2 tabbed files on the first 2 fields, and filling the missing values with 0. The 3rd column in each file is constant for the entire file.
file1
12658699 ST5 XX2720 0 1 0 1
53039541 ST5 XX2720 1 0 1.5 1
file2 ... (6 Replies)
Dear All,
I have many files formatted like this:
file1.txt:
1/2-SBSRNA4 18
A1BG 3
A1BG-AS1 6
A1CF 0
A2LD1 1
A2M 1160
file2.txt
1/2-SBSRNA4 53
A1BG 1
A1BG-AS1 7
A1CF 0
A2LD1 3
A2M 2780 (5 Replies)
Discussion started by: paolo.kunder
5 Replies
LEARN ABOUT DEBIAN
letterize
LETTERIZE(1) Miscellanea LETTERIZE(1)NAME
letterize_ - phone-number to letter-mnemonic generator
SYNOPSIS
letterize nnnnnnn
DESCRIPTION
This program tries to help you find a letter mnemonic matching a given phone number.
It emits to standard output each possible pronounceable mnemonic, one per line, using the American standard mapping of dial letters to
numbers (2 goes to ABC, 3 to DEF, 4 to GHI, 5 to JKL, 6 to MNO, 7 to PRS, 8 to TUV, 9 to XYZ).
The program uses a table of pronounceable letter-triples derived from a dictionary scan. Each potential mnemonic must be such that all of
its letter-triples are in the table to be emitted. About 30% of possible triples are considered pronounceable.
A typical 7-digit phone number has 19,683 possible mnemonics, but this test usually cuts the list down to a few hundred or so, a reasonable
number to eyeball-check. For some numbers, the list will, sadly, be empty.
It's best to leave out punctuation such as dashes and parens.
BUGS
The filtering method doesn't know what plausible medial triples are not reasonable at the beginnings and ends of words.
I'm not sure what table position 0 (which is what 0 and 1 are mapped to) means. If you figure it out, you tell me. I really should have
generated my own table, but that would have been more work than this seemed worth -- if your number contains either, you probably need to
generate your mnemonic in disjoint pieces around the digits anyway.
AUTHOR
Eric S. Raymond esr@snark.thyrsus.com. It's based on a table of plausible letter-triples that had no name attached to it. Surf to
http://www.catb.org/~esr/ for updates and related resources.
letterize 05/30/2012 LETTERIZE(1)