1

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

view story
linux-howto

http://www.unix.com – 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 and 5 (including). How do I go about doing that? Thanks! Input: Code: a -0.01 5 b -0.02 3 c 0 3 d 0.005 6 Output: Code: a -0.01 5 c 0 3 (HowTos)

Shoutmeloud's picture
Submitted by Shoutmeloud on 10/19/2012

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

Hi,

I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks!

Input:

Code: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output:

Code: 1 2 ZYX OPW

Hi,

I have a tab delimited text file with two columns where the second column takes on values between 1 and 6 (including). If the value of the second column, includes 1,2,3 I want to replace it with LOW. If it is 4,5,6 I want to replace it with HIGH. How do I go about doing that? Thanks

Input:

Code: A 1 B 4 C 6 Output

Code: A LOW B HIGH C HIGH

I've a text file with below values viz. multiple rows with same values in column 3, 4 and 5, which need to be considered as duplicates. For all such cases, the rows from second occurrence onwards should be modified in a way that their values in first two columns are replaced with values as in first occurrence.

Hi All,

I have a big file with 232 columns and 9 million rows, I want to delete all rows with same column values in col3 through col232. Also the output should be sorted based on first 2 columns.

Here is a reduced example with 6 columns.

Dear Gurus,

I have tab-delimited text files with matrix containing values. The first column is a identifier and other columns have the corresponding values.

Hello to all.

This is first post. Kindly excuse me if I do not adhere to any rules and regulations of this forum.

I have a file containing some rows with three columns each per row(separeted by a space). There are certain rows for which first two columns have same value but the value in third column is different.

Hi Gurus,

I have 100 tab-delimited text files each with 21 columns. I want to extract only 2nd and 5th column from each text file. However, the values in both 2bd and 5th column contain duplicate values but the combination of these values in a row are not duplicate. I want to extract only those entries which are unique based on the first appearance of value in the 5th column.

Ex.

Hi,

I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt.

Hello All,

I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B. Note that my data has some other columns(not shown here) too (around 100) after col2.

Code: Tool,Data A,1 A,3 A,5 .... so on B,2 B,4 .... so on I want to convert all odd numbers to even numbers( adding 1)..