Re ordering lines - Awk Post: 302543740

Sponsored Content

Top Forums Shell Programming and Scripting Re ordering lines - Awk Post 302543740 by quincyjones on Tuesday 2nd of August 2011 01:45:02 AM

08-02-2011

Registered User

Re ordering lines - Awk

Is it possible to re-order certain rows as columns (of large files).
Few lines from the file for reference.

input

Code:

Splicing Factor: Tra2beta, Motif: aaguguu, Cutoff: 0.5000
Sequence Position	Genomic Coordinate	K-mer     	Score   
97               	chr1:67052604     	uacuguu   	0.571   
147              	chr1:67052554     	augugua   	0.536   
166              	chr1:67052535     	aaauuuu   	0.500   
226              	chr1:67052475     	aauugug   	0.612   
Splicing Factor: SRp20, Motif: wcwwc, Cutoff: 0.7200
Sequence Position	Genomic Coordinate	K-mer     	Score   
302              	chr1:67052399     	ucauc     	0.875   
349              	chr1:67052352     	acauc     	0.740

output

Code:

Splicing_Factor	Motif	Cutoff	Sequence_Position	Genomic_Coordinate	K-mer	Score   
Tra2beta	aaguguu	0.5000	97	chr1:67052604     	uacuguu   	0.571
Tra2beta	aaguguu	0.5000	147	chr1:67052554     	augugua   	0.536
Tra2beta	aaguguu	0.5000	166	chr1:67052535     	aaauuuu   	0.500 
Tra2beta	aaguguu	0.5000	226	chr1:67052475     	aauugug   	0.612
SRp20	wcwwc	0.7200	302	chr1:67052399	ucauc	0.875   
SRp20	wcwwc	0.7200	349	chr1:67052352	acauc	0.740

Last edited by quincyjones; 08-02-2011 at 02:52 AM..

quincyjones

View Public Profile for quincyjones

Find all posts by quincyjones

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

proper ordering of o/p values

Hi, Below is my script which creates a file: #!/bin/sh if then echo "Enter bill period " echo "Syntax: sh cpd.sh G08" exit fi sqlplus uname/pwd@dbname <<EOF set WRAP off set FEEDBACK off set PAGESIZE 0 set VERIFY off

2. Shell Programming and Scripting

trying to make an AWK code for ordering numbers in a column from least to highest

Hi all, I have a large column of numbers like 5.6789 2.4578 9.4678 13.5673 1.6589 ..... I am trying to make an awk code so that awk can easily go through the column and arrange the numbers from least to highest like 1.6589 2.4578 5.6789 ....... can anybody suggest, how can I do...

3. Homework & Coursework Questions

word ordering problem HELP please (linux)

Hi guys I need you ,please help me i have to do this for tomorow and i don't understand how to do Q1 : Order the words of RADIO.txt by frequency Q2 : Order the words of RADIO.txt in alphab�tique order Q3 : Order the words of RADIO.txt par ordre "rhymique" (exemple, put togeder words which are...

4. Shell Programming and Scripting

ordering a data file

With an input file like this: How can I get an output like this? (In the quoted examples, the "_" sign represents an empty space) Note that there are some minus signs and no spaces, in the example above the first character of the first line is an empty space, so each number spans 10...

5. Shell Programming and Scripting

Appending lines with word frequencies, ordering and indexing a column

Dear All, I have the following input data: w1 20 g1 w1 10 g1 w2 12 g1 w2 23 g1 w3 10 g1 w3 17 g1 w3 12.5 g1 w3 21 g1 w4 11 g1 w4 13.2 g1 w4 23 g1 w4 18 g1 First I seek to find the word frequencies in col1 and sort col2 in ascending order for each change in a col1 word. Second,...

6. Shell Programming and Scripting

Re-ordering data

input Predictions for job: 1299399580 ********************************************** gg18_qqq10_100017878_100017978_- ============================================================================== zzz Factor: XXX, ttt: crsmsgw, Cutoff: 0.6429 seqe Position fff Coordinate K-mer Score ...

7. Shell Programming and Scripting

ordering

file1 1 SNP2 3 1 SNP3 3 1 SNP5 4 2 SNP1 4 2 SNP4 4 file2 SNP1 1 1 1 SNP5 5 5 5 SNP4 4 4 4 SNP2 2 2 2 SNP3 1 1 1 desired output

8. Shell Programming and Scripting

Random ordering

1 2 4 5 3 I would like to use a script so that i can randomly rearrange these numbers such as 3 5 2 4 1 Thanks!

9. Shell Programming and Scripting

Ordering batch number

Hi, Could some one please help to order the batch number in sequence. I will be getting bunch of files with batch number in folder1 which are not in sequence. I need to move all files from folder1 to folder2 with batch number in sequence. Header record looks like PROCESS1...

10. Shell Programming and Scripting

awk to print missing and keep sequential ordering if not found

The below awk in bold will look for the ids in file1 in $2 of file2 and if they match print the line in file2. If an id is missing or not found in file2 (like BMPR2 in line4 of file1) I can not figure out how to add it to them to the lines in the output as missing in $3 following the same format....

LEARN ABOUT NETBSD

scc

SCC(4)							   BSD Kernel Interfaces Manual 						    SCC(4)

NAME

     scc -- Zilog 8530 Serial Communications Controller interface

SYNOPSIS

     scc* at ioasic? offset ?

DESCRIPTION

     The scc driver provides support for the Zilog 8530 Serial Communications Controller (SCC) via the IOASIC found on DECstation 5000 models in
     the /100, /20, and /240 series (supported by NetBSD/pmax).

     Each SCC device has two serial ports.  The DECstation 5000 model 20 provides one SCC device.  Other models provide two, but one port of each
     device is dedicated to mouse and keyboard input, respectively.

     Input and output for each line may set to one of following baud rates: 50, 75, 110, 134.5, 150, 300, 600, 1200, 1800, 2400, 4800, 9600,
     19200, 38400, or 57600.

     Speeds up to 230400 are supported by the chip and the motherboard, but speeds higher than 57600 do not work reliably without an external
     clock signal.

FILES

     /dev/ttya
     /dev/ttyb
     /dev/ttyc
     /dev/ttyd

     The mapping from units to serial-hardware outlets is idiosyncratic.  The even ports are wired serial connectors and the odd-numbered ports
     are reserved for mouse and keyboard.

     On machines with one port like Personal DECstations, the single device is ttya.

     On the 5000/1xx and 5000/2xx, the first serial port (default serial console) is ttyc and the second port is ttya.

SEE ALSO

     intro(4), ioasic(4), ttys(5), MAKEDEV(8)

HISTORY

     The scc driver first appeared in 4.4BSD.

     The scc driver was also used for the IOASIC SCC found in DEC Alpha model 3000 TurboCHANNEL based systems; NetBSD/alpha has since been con-
     verted to use the machine-independent zstty(4).

BUGS

     The IOASIC provides internal DMA channels that can be programmed to transfer up to 4096 bytes of data into, or out, of an SCC without further
     software intervention.  This feature of the IOASIC is not yet supported.

     The mapping from device-special files (major and minor number) to chip and port is arguably backwards.  ULTRIX tries to hide the hardware
     mapping, but NetBSD does not.  Users wanting to use ULTRIX compatible tty names /dev/tty0 and /dev/tty1 for the scc comm-port lines should
     make links or device-special files which match their hardware setup.

BSD
								  April 24, 2003							       BSD