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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting values based on line-column numbers from multiple text files

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 ...

2. Shell Programming and Scripting

Extracting rows and columns in a matrix based on condition

Hi I have a matrix with n rows and m columns like below example. i want to extract all the pairs with values <200. Input A B C D A 100 206 51 300 B 206 100 72 48 C 351 22 100 198 D 13 989 150 100 Output format A,A:200 A,C:51 B,B:100...

3. UNIX for Dummies Questions & Answers

Fixed length file extracting values in columns

How do I extract values in a few columns in a row of a fixed length file? If there are 8 columns and I need to extract values of 2nd,4th and 6 th columns, how do i do that? I used cut command, this I used only for one column. How do I do it more than one column? The below command will give...

4. Shell Programming and Scripting

Checking for ranges based on 2 columns

Hi, I have a file with 6 columns. I want to check if column 1 and 2 fall between column 5 and 6 I want to call them as "TRUE_genes" if not then call them as "FALSE_genes". I can do it for checking one column but how to mention about two columns. file1 110371373...

5. 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!

6. Shell Programming and Scripting

extracting columns falling within specific ranges for multiple files

Hi, I need to create weekly files from daily records stored in individual monthly filenames from 1999-2010. my sample file structure is like the ones below: daily record stored per month: 199901.xyz, 199902.xyz, 199903.xyz, 199904.xyz ...199912.xyz records inside 199901.xyz (original data...

7. 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...

8. 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...

9. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on the first column

10. Shell Programming and Scripting

Selecting rows based on values in columns

Hi My pipe delimited .txt file contains rows with 10 columns. Can anyone advise how I output to file only those rows with the letters �ci' as the first 2 characters in the 3rd column ? Many thanks

LEARN ABOUT SUSE

pfscut

pfscut(1)						      General Commands Manual							 pfscut(1)

NAME

       pfscut - Extract a rectangle out of a frame in PFS stream

SYNOPSIS

       pfscut [--left <columns>] [--right <columns>] [--top <rows>] [--bottom <rows>] [--width <new_width>] [--height <new_height>] [--help] [x_ul
       y_ul x_br y_br]

DESCRIPTION

       Extract a rectangle out of each frame in PFS stream. You can either specify x and y coordinates of upper left and lower right  corner  (the
       coordinates start with 0 and rise in the left-to-right and up-to-botton directions) or give a combination of the options listed below.

OPTIONS

       --left <columns>, -l <columns>
	      Number of columns to be cut out from the left edge of an image.

       --right <columns>, -r <columns>
	      Number of columns to be cut out from the right edge of an image.

       --top <rows>, -t <rows>
	      Number of rows to be cut out from the top edge of an image.

       --bottom <rows>, -b <rows>
	      Number of rows to be cut out from the bottom edge of an image.

       --width <new_width>, -W <new_width>
	      Width of an output image. Note that --width can be mixed with either --left or --right option.

       --height <new_height>, -H <new_height>
	      Height of an output image. Note that --height can be mixed with either --top or --bottom option.

       --help, -h
	      Print a list of commandline options.

EXAMPLES

       pfsin image.hdr | pfscut --left 20 --top 5 | pfsout out.hdr
	      Cut out 20 columns from the left and 5 rows from the top edge of image.hdr and save frame as out.hdr.

       pfsin image.hdr | pfscut --left 20 --width 400 | pfsout out.hdr
	      Cut out 20 columns from the left edge of image.hdr, and create output image 400 pixels in width.

       pfsin image.hdr | pfscut 0 0 511 511 | pfsout out.hdr
	      Cut  left-upper  part  of  the  image of the size 512x512 (note that coordinates start with 0 and 512 is the last row/column that is
	      included in the resulting image).

       SEE ALSO
	      pfsin(1) pfsout(1)

BUGS

       Please report bugs and comments to Dorota Zdrojewska <dzdrojewska@wi.ps.pl>.

																	 pfscut(1)

UNIX for Dummies Questions & Answers