Sponsored Content
Top Forums Shell Programming and Scripting printing certain elelment of a column Post 302715789 by johnkim0806 on Monday 15th of October 2012 11:47:54 AM
Old 10-15-2012
printing certain elelment of a column

"File1.txt"
Code:
CHR SNP BP ANNOT
8 rs1878374 127974042 MYC(-843.5kb)|FAM84B(+334.4kb)
2 rs2042077 16883103 VSNL1(-702.2kb)|SMC6(-825.5kb)|RAD51AP2(-672.4kb)|MYCN(+878.5kb)|MSGN1(-978.2kb)|GEN1(-915.6kb)|FAM49A(+172.5kb)
12 rs10431347 3023955 TULP3(+103.4kb)|TSPAN9(-32.86kb)|TEAD4(+3.852kb)|PRMT8(-446.7kb)|PARP11(-764.3kb)|NRIP2(+209.5kb)|ITFG2(+219.6kb)|FOXM1(+167.4kb)|FKBP4(+240.6kb)|EFCAB4B(-603.4kb)|CACNA1C(+346.6kb)|C12orf32(+155.1kb)
5 rs10071904 41255697 TTC33(+463.9kb)|RPL37(+384.6kb)|PTGER4(+526.1kb)|PRKAA1(+421.6kb)|PLCXD3(-87.11kb)|OXCT1(-510.2kb)|LOC285636(-684.5kb)|FLJ40243(+148.5kb)|FBXO4(-705.4kb)|CARD6(+364.5kb)|C7(+236.9kb)|C6(0)

I want to print ANNOT whose absolute value of kb is the smallest.
so the desired output will be

Code:
CHR SNP BP ANNOT
8 rs1878374 127974042 FAM84B
2 rs2042077 16883103 FAM49A
12 rs10431347 TEAD4
5 rs10071904 41255697 C6

Thanks!

Last edited by Scrutinizer; 10-15-2012 at 12:51 PM.. Reason: code tags instead of quote tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Printing highest value from one column

Hi, I have a file that looks like this: s6 98 s6 91 s6 56 s5 32 s5 10 s5 4 So what I want to do is print only the highest value for each value in the column: So the file will look like this: s6 98 s5 32 Thanks (4 Replies)
Discussion started by: phil_heath
4 Replies

2. Shell Programming and Scripting

regarding about printing row to column

Hello, I got data like that, =111 A= alpha B= 1 C= qq D= 45 F= ss G= 334 =1234 A= B= 2w C= D= 443 F= G= =3434 A= B= e3e (5 Replies)
Discussion started by: davidkhan
5 Replies

3. UNIX for Dummies Questions & Answers

creating a file using the fist column and printing second column

Hello all. I have a problem that I need help solving. I would like to convert the following file: human pool1_12 10e-02 45 67 human pool1_1899 10e-01 45 29 human pool1_1829 10e-01 43 26 horse pool1_343 10e-20 65 191 horse pool1_454 10e-09 44 43... (5 Replies)
Discussion started by: viralnerd
5 Replies

4. Solaris

Printing a particular column[autosys]

Dear All, I'm using autosys in my production system. My concern is as follows: autosys -j <some_job_nm> Output: Job Name Last Start Last End ST Run Pri/Xit ... (1 Reply)
Discussion started by: saps19
1 Replies

5. UNIX for Dummies Questions & Answers

Printing a particular column using SED

Hi, i want to display only the particular column using SED command. For example, ps -ef|grep ash |sed -n '1p'|cut -d ' ' -f2   this gives 29067 ps -ef|grep ash |sed -n '1p'|awk '{print $2}'    this also gives the same  in the same way i need the solution using sed. Please... (4 Replies)
Discussion started by: pandeesh
4 Replies

6. Shell Programming and Scripting

Printing second column of several files into one

HI All, I have exactly 100 text files with extension .txt. The files contain numbers like this: 1.txt 0.4599994 65914 0.40706193 190743 0.39977244 185019 0.39831382 74906 0.3915928 122428 0.38844505 39999 0.38820446 72691 0.38787442 176430 0.38670844 28791 0.38597047 91091... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

7. Shell Programming and Scripting

Column printing in awk

Experts, i have a following file containing data in following manner. 1 2480434.4 885618.6 0.00 1948.00 40.00 1952.00 ... (6 Replies)
Discussion started by: Amit.saini333
6 Replies

8. UNIX for Dummies Questions & Answers

Printing out lines that have the same value in the first column but different value in the second

Hi, I have a text file that looks like the following: ILMN_1343291 6 74341083 74341772 ILMN_1343291 6 74341195 74341099 ILMN_1343295 12 6387581 6387650 ILMN_1651209 1 1657001 1657050 ILMN_1651209 5 83524260 83524309 I... (1 Reply)
Discussion started by: evelibertine
1 Replies

9. Shell Programming and Scripting

Inconsistent column printing

Hi, I have a file that has inconsistently numbered columns. Like row1 has 23 columns, and row 2 has 34 columns etc. I would like to re-order the first 8 columns as required and from the 9th column till the end, I would like to print it as it is. I tried to read the re-ordered 8 columns... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

10. Shell Programming and Scripting

Printing a 2 column output using scripts

Hi, I'm fairly new to scripting and Unix. I'm having trouble printing the number of directories and number of files in all the directories in 2 columns using scripts. #!/bin/bash echo "# of Directories --------- # of Messages/Files " numDir= $(find . -type d | wc -l) numMsg= $(find .... (4 Replies)
Discussion started by: nuclearpenguin
4 Replies
SBNI(4) 						 BSD/i386 Kernel Interfaces Manual						   SBNI(4)

NAME
sbni -- Granch SBNI12 leased line modem driver SYNOPSIS
device sbni DESCRIPTION
The sbni driver provides support for leased line modems of following models: o SBNI12-02, SBNI12D-02 o SBNI12-04, SBNI12D-04 o SBNI12-05, SBNI12D-05, ISA and PCI o SBNI12-10, SBNI12D-10, ISA and PCI and a kit for data link over a voice band: o SBNI12-11, SBNI12D-11, ISA and PCI. In addition to the standard port and IRQ specifications, the sbni driver also supports a number of flags which can set baud rate, receive level, and low three bytes of Ethernet MAC-address (high three are always 00:ff:01), because Granch modems are presented to the system as Ethernet-like network cards. The high byte of the flags is a bit field, it is used to specify SBNI adapter receive level/baud rate: Bits 0-3: receive level (0x00..0x0f) Bits 4-5: baud rate number: 00 - 0 baud rate (2Mb in fast mode/500kb in slow) 01 - 1 baud rate (1Mb/250kb) 10 - 2 baud rate (500kb/125kb) 11 - 3 baud rate (250kb/62.5kb) Bit 6: use fixed receive level if bit 6 is set then receive level will be set according to bits 0-3 value, otherwise receive level will be autodetected Bit 7: use fixed baud rate if bit 7 is set then baud rate will be set according to bits 4-5 value, otherwise baud rate is set to 2Mb FILES
The sources for the driver reside in: /sys/dev/sbni/if_sbni.c /sys/dev/sbni/if_sbnireg.h /sys/dev/sbni/if_sbnivar.h SEE ALSO
arp(4), netintro(4), ifconfig(8) HISTORY
The sbni device driver first appeared in FreeBSD 4.6. AUTHORS
The sbni device driver for FreeBSD 4.x was written by Denis I. Timofeev, partially based on David Greenman's ed(4) driver. Earlier versions (available on ftp.granch.com) were written by Alexey V. Zverev. SBNI12 hardware was designed by Alexey V. Chirkov. BSD
January 8, 2002 BSD
All times are GMT -4. The time now is 08:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy