Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extracting rows from a text file if the value of a column falls between a certain range
Top Forums UNIX for Dummies Questions & Answers Extracting rows from a text file if the value of a column falls between a certain range Post 302768551 by user8 on Friday 8th of February 2013 08:19:24 PM
Old 02-08-2013
If I understood correctly, you could try this:

Code:
awk '$2>($6-1000000) || $2<($7+1000000)'

While thinking twice, I came to the conclusion that the above should better read

Code:
awk '$2>($6-1000000) && $2<($7+1000000)'

Last edited by user8; 02-09-2013 at 07:46 PM.. Reason: && rather than ||
This User Gave Thanks to user8 For This Post:
evelibertine
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

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... (1 Reply)
Discussion started by: evelibertine
1 Replies

2. UNIX for Dummies Questions & Answers

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... (1 Reply)
Discussion started by: evelibertine
1 Replies

3. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on numerical values of a column

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

Extracting rows from a space delimited text file based on the values of a column

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

Extracting the last column of a text file

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)
Discussion started by: evelibertine
1 Replies

6. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on the values of two columns (given ranges)

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. Shell Programming and Scripting

Printing rows based on column range

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)
Discussion started by: Sanchari
1 Replies

8. Shell Programming and Scripting

Extracting the column containing URL from a text file

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)
Discussion started by: csim_mohan
0 Replies

9. Shell Programming and Scripting

Extracting the column containing URL from a text file

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)
Discussion started by: csim_mohan
0 Replies

10. Shell Programming and Scripting

Extracting the column containing URL from a text file

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

tempest_for_eliza

TEMPEST_FOR_ELIZA(1)					      General Commands Manual					      TEMPEST_FOR_ELIZA(1)

NAME

       tempest_for_eliza - play songs with your computer monitor and AM radio

SYNOPSIS

       tempest_for_eliza pixelclock x 1000000 HDisplay VDisplay HTotal radio frequency music file

DESCRIPTION

       This program displays patterns on a computer monitor that can produce musical tones on AM radios tuned to the proper frequency.

OPTIONS

       pixelclock x 1000000, HDisplay, VDisplay, and HTotal all should be the same each time for your monitor.	Use the xvidtune(1) application to
       determine these values.

       As the name suggests, for the pixelclock parameter multiply the result given by xvidtune(1) by 1000000.

       A usual sensible value for radio frequency is 10000000, or 10Mhz.

EXAMPLES

       $ tempest_for_eliza 119000000 1680 1050 1840 10000000 /usr/share/doc/tempest-for-eliza/songs/forelise

       Start TFE on a monitor with pixelclock 119, 1680x1050 resolution, and a VDisplay of 1840, to be accessed in the 10Mhz band.

AUTHORS

       The original idea for tempest_for_eliza	was  taken  from  Pekka  Riikonen,  who  wrote	the  original  tempest-AM-0.9  application.   tem-
       pest_for_eliza was written by Erik Thiele.

       This manual page was written by Luke Faraone luke@faraone.cc for the Debian GNU/Linux system, but its use elsewhere is encouraged.

SEE ALSO

       tempest_for_mp3(1), xvidtune(1),

       Additional documentation may be found at <http://www.erikyyy.de/tempest/>.

tempest_for_eliza manual					  April 18, 2010					      TEMPEST_FOR_ELIZA(1)
All times are GMT -4. The time now is 04:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy