Extracting rows from a text file if the value of a column falls between a certain range
Hi,
I have a file that looks like the following:
I want to extract all the lines where the value in column 2 is within +/- 1,000,000 the range given by the values in columns 6 and 7 (i.e. either between the values in columns 6 and 7, or less than 1,000,000 smaller from the value in column 6, or less than 1,000,000 greater from the value in column 7) Thanks!
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)
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... (1 Reply)
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)
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)
I would like to extract the last column of a text file but different rows of the text file have different numbers of columns. How do I go about doing that? Thanks! (1 Reply)
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)
Hello, I have a file with nearly 57K lines. I want to filter the lines based on the range of values in a column. For e.g. print lines whose 3rd filed is >=0.02.
Input file:
LOC_Os09g32030 LOC_Os02g18880 0.0200037219149773 undirected NA NA
LOC_Os03g58630 LOC_Os09g35690 ... (1 Reply)
I have the file like this:
Timestamp URL Text 1331635241000 http://example.com Peoples footage at www.test.com,http://example4.com 1331635231000 http://example1.net crack the nuts http://example6.com 1331635280000 http://example2.net ... (0 Replies)
I have the file like this:
Timestamp URL Text 1331635241000 http://example.com Peoples footage at www.test.com,http://example4.com 1331635231000 http://example1.net crack the nuts http://example6.com 1331635280000 http://example2.net ... (0 Replies)
I have the file like this:
Timestamp URL Text 1331635241000 http://example.com Peoples footage at www.test.com,http://example4.com 1331635231000 http://example1.net crack the nuts http://example6.com 1331635280000 http://example2.net ... (3 Replies)
Discussion started by: csim_mohan
3 Replies
LEARN ABOUT DEBIAN
ioping
IOPING(1) User Commands IOPING(1)NAME
ioping - simple disk I/O latency monitoring tool
SYNOPSYS
ioping [-LCDRq] [-c count] [-w deadline] [-p period] [-i interval] [-s size] [-S wsize] [-o offset] device|file|directory
ioping -h | -v
DESCRIPTION
This tool lets you monitor I/O latency in real time.
OPTIONS -c count
Stop after count requests.
-w deadline
Stop after deadline time passed.
-p period
Print raw statistics for every period requests.
-i interval
Set time between requests to interval (1s).
-s size
Request size (4k).
-S size
Working set size (1m).
-o offset
Offset in input file.
-L Use sequential operations rather than random. This also sets request size to 256k (as in -s 256k).
-C Use cached I/O.
-D Use direct I/O.
-R Disk seek rate test (same as -q -i 0 -w 3 -S 64m).
-q Suppress human-readable output.
-h Display help message and exit.
-v Display version and exit.
Argument suffixes
For options that expect time argument (-i and -w), default is seconds, unless you specify one of the following suffixes (case-insensitive):
us, usec
microseconds
ms, msec
milliseconds
s, sec seconds
m, min minutes
h, hour
hours
For options that expect "size" argument (-s, -S and -o), default is bytes, unless you specify one of the following suffixes (case-insensi-
tive):
s disk sectors (a sector is always 512).
k, kb kilobytes
p memory pages (a page is always 4K).
m, mb megabytes
g, gb gigabytes
t, tb terabytes
For options that expect "number" argument (-p and -c) you can optionally specify one of the following suffixes (case-insensitive):
k kilo (thousands, 1 000)
m mega (millions, 1 000 000)
g giga (billions, 1 000 000 000)
t tera (trillions, 1 000 000 000 000)
EXIT STATUS
Returns 0 upon success. The following error codes are defined:
1 Invalid usage (error in arguments).
2 Error during preparation stage.
3 Error during runtime.
EXAMPLES
ioping .
Show disk I/O latency using the default values and the current directory, until interrupted.
ioping -c 10 -s 1M /tmp
Measure latency on /tmp using 10 requests of 1 megabyte each.
ioping -R /dev/sda
Measure disk seek rate.
ioping -RL /dev/sda
Measure disk sequential speed.
SEE ALSO
Homepage <http://code.google.com/p/ioping/>.
AUTHORS
This program was written by Konstantin Khlebnikov <koct9i@gmail.com>.
Man-page was written by Kir Kolyshkin <kir@openvz.org>.
July 2011 IOPING(1)