09-19-2011
Extracting rows from a text file based on the first column
I have a tab delimited text file where the first column can take on three different values : 100, 150, 250. I want to extract all the rows where the first column is 100 and put them into a separate text file and so on. This is what my text file looks like now:
100 rs3794811 0.01 0.3434
100 rs8066551 0.01 0.4541
100 rs7215271 0.02 0.2592
100 rs6565733 0.00 0.8408
150 rs1106175 0.00 0.5562
150 rs8064924 0.00 0.8014
150 rs7224313 0.03 0.1484
150 rs7217319 0.02 0.2413
150 rs4890199 0.02 0.2033
150 rs4890183 0.03 0.1351
250 rs4424950 0.02 0.1715
250 rs7503116 0.03 0.1474
250 rs1136388 0.04 0.0801
250 rs1609550 0.02 0.2784
250 rs11654695 0.01 0.4495
250 rs11649979 0.01 0.4060
250 rs12938802 0.00 0.5404
250 rs1138504 0.01 0.3606
How do I go about doing that? Thanks!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am processing a file and would like to delete duplicate records as indicated by one of its column. e.g.
COL1 COL2 COL3
A 1234 1234
B 3k32 2322
C Xk32 TTT
A NEW XX22
B 3k32 ... (7 Replies)
Discussion started by: risk_sly
7 Replies
2. UNIX for Dummies Questions & Answers
I have a tab delimited text file where the first column can take on three different values : 100, 150, 250. I want to extract all the rows where the first column is 100 and put them into a separate text file and so on. This is what my text file looks like now:
100 rs3794811 0.01 0.3434... (1 Reply)
Discussion started by: evelibertine
1 Replies
3. UNIX for Dummies Questions & Answers
I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001.
My input:
rs10082730 9e-08 12 46002702
rs2544081 1e-07 12 46015487
rs1425136 1e-06 7 35396742
rs2712590... (1 Reply)
Discussion started by: evelibertine
1 Replies
4. UNIX for Dummies Questions & Answers
I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies
5. UNIX for Dummies Questions & Answers
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between... (1 Reply)
Discussion started by: evelibertine
1 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a file that looks like the following:
10 100080417 rs7915867 ILMN_1343295 12 6243093 7747537
10 100190264 rs2296431 ILMN_1343295 12 6643093 6647537
10 100719451 SNP94374 ILMN_1343295 12 6688093 7599537 ... (1 Reply)
Discussion started by: evelibertine
1 Replies
9. Shell Programming and Scripting
Hi all,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (3 Replies)
Discussion started by: Vivekit82
3 Replies
10. Shell Programming and Scripting
Dear All,
I have to solve the following problems with multiple tab-separated text file but I don't know how. Any help would be greatly appreciated. I have access to Linux mint (but not as a professional).
I have multiple tab-delimited files with the following structure:
file1:
1 44
2 ... (5 Replies)
Discussion started by: Bastami
5 Replies
LEARN ABOUT REDHAT
kbdrate
KBDRATE(8) Linux Programmer's Manual KBDRATE(8)
NAME
kbdrate - reset the keyboard repeat rate and delay time
SYNOPSIS
kbdrate [ -s ] [ -r rate ] [ -d delay ]
DESCRIPTION
kbdrate is used to change the keyboard repeat rate and delay time. The delay is the amount of time that a key must be depressed before it
will start to repeat.
Using kbdrate without any options will reset the repeat rate to 10.9 characters per second (cps) and the delay to 250 milliseconds (ms) for
Intel- and M68K-based systems. These are the IBM defaults. On SPARC-based systems it will reset the repeat rate to 20 cps and the delay to
200 ms.
OPTIONS
-s Silent. No messages are printed.
-r rate
Change the keyboard repeat rate to rate cps. For Intel-based systems, the allowable range is from 2.0 to 30.0 cps. Only certain,
specific values are possible, and the program will select the nearest possible value to the one specified. The possible values are
given, in characters per second, as follows: 2.0, 2.1, 2.3, 2.5, 2.7, 3.0, 3.3, 3.7, 4.0, 4.3, 4.6, 5.0, 5.5, 6.0, 6.7, 7.5, 8.0,
8.6, 9.2, 10.0, 10.9, 12.0, 13.3, 15.0, 16.0, 17.1, 18.5, 20.0, 21.8, 24.0, 26.7, 30.0. For SPARC-based systems, the allowable
range is from 0 (no repeat) to 50 cps.
-d delay
Change the delay to delay milliseconds. For Intel-based systems, the allowable range is from 250 to 1000 ms, in 250 ms steps. For
SPARC systems, possible values are between 10 ms and 1440 ms, in 10 ms steps.
-V Display a version number and exit.
BUGS
Not all keyboards support all rates.
Not all keyboards have the rates mapped in the same way.
Setting the repeat rate on the Gateway AnyKey keyboard does not work. If someone with a Gateway figures out how to program the keyboard,
please send mail to util-linux@math.uio.no.
All this is very architecture dependent. Nowadays kbdrate first tries the KDKBDREP and KIOCSRATE ioctls. (The former usually works on an
m68k machine, the latter for SPARC.) When these ioctls fail an ioport interface as on i386 is assumed.
FILES
/etc/rc.local
/dev/port
/dev/kbd
Linux 1.1.19 22 June 1994 KBDRATE(8)