Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: deleting a row if a certain column is below a certain number
Top Forums UNIX for Dummies Questions & Answers deleting a row if a certain column is below a certain number Post 302402194 by Pep Puigvert on Tuesday 9th of March 2010 06:53:08 AM
Old 03-09-2010
deleting a row if a certain column is below a certain number
How can you delete a row if a certain column is bigger than a certain number?
I have the following input:

Code:
20080709 20081222 95750 1 0 0.02 94.88
20080709 20081222 95750 2 0 0.89 94.88

Code:
20080709 20081222 9575 1 0 0 94.88
20080709 20081222 9575 2 0 0 94.88
20080709 20081222 9587.5 1 0 0 94.88
20080709 20081222 9587.5 2 0 0 94.88
20080709 20081222 95875 1 0 0.015 94.88
20080709 20081222 95875 2 0 1.01 94.88
20080709 20081222 96000 1 0 0.01 94.88
20080709 20081222 96000 2 0 1.13 94.88
20080709 20081222 9600 1 0 0 94.88
20080709 20081222 9600 2 0 0 94.88



I would like to delete all rows in red since the third column is smaller than 10000.

Code:










Code:



20080709 20081222 95750 1 0 0.02 94.88
20080709 20081222 95750 2 0 0.89 94.88
20080709 20081222 95875 1 0 0.015 94.88
20080709 20081222 95875 2 0 1.01 94.88
20080709 20081222 96000 1 0 0.01 94.88
20080709 20081222 96000 2 0 1.13 94.88










 

I have the following code in perl but is not working since I get the following error:

 

Use of uninitialized value in split at ./format_10000.perl line 9.




Code:



#!/usr/bin/perl -w
while(<STDIN>) {
 my ( $col1, $col2, $col3, $col4, $col5, $col6, $col7 )
  = split ( /\s+/, $_ ); # split current line where you at least one space or tab...
 next if $strike_price > 10000;
 print STDOUT $_; # print current line. We did not chomp it, so no need for an extra \n.
}







Can anyone help me? 

 

Thanks a lot in advance!



Pep







        

        

       



            
            
            
            


            

            
            




            
                
            

            

        



        


        


 


        

        
        

        


 

            
        




















	


		


		 
		
			












	
	









    







10 More Discussions You Might Find Interesting











1. UNIX for Dummies Questions & Answers






 deleting a row if a certain column is below a certain number




How can you delete a row if a certain column is bigger than a certain number? 
  
I have the following input: 
  
 
20080709 20081222 95750 1 0 0.02 94.88 
20080709 20081222 95750 2 0 0.89 94.88 
20080709 20081222 9575 1 0 0 94.88 
20080709 20081222 9575 2 0 0 94.88 
20080709 20081222 9587.5 1 0 0... (1 Reply)





Discussion started by: Pep Puigvert



1 Replies








2. UNIX for Dummies Questions & Answers






 Adding a column with the row number using awk




Is there anyway to use awk to add a first column to my data that automatically goes from 1 to n , where n is the numbers of my rows?:confused: (4 Replies)





Discussion started by: cosmologist



4 Replies








3. Shell Programming and Scripting






 Count the number or row with same value in a column




This is the source file, we called it errorlist.out 
 
196    server_a    server_unix_2    CD 
196    server_b    server_win_1    CD 
196    server_c    server_win_2    CD 
196    server_bd    server_unix_2    CD 
196    server_d    server_unix_2    CD 
196    server_es    server_win_1    CD 
196  ... (14 Replies)





Discussion started by: sQew



14 Replies








4. Shell Programming and Scripting






 How to print column based on row number




Hi, 
I want to print column value based on row number say multiple of 8. 
 
Input file: 
line 1 67  34 
line 2 45  57 
. . . 
. . .  
line 8 12  46 
. . . 
. . . 
line 16 24  90 
. . . 
. . . 
line 24 49  67 
 
Output 
46 
90 
67 (2 Replies)





Discussion started by: Surabhi_so_mh



2 Replies








5. Shell Programming and Scripting






 Deleting a row based on fetched value of column




Hi, 
 
I have a file which consists of two columns but the first one can be varying in length like 
 
123456789   0abcd 
123456789   0abcd 
4015        0   0abcd 
5000            0abcd 
 
I want to go through the file reading each line, count the number of characters in the first column and delete... (2 Replies)





Discussion started by: swasid



2 Replies








6. Shell Programming and Scripting






 Deleting row if all column values are a particular string




Hello, 
 
I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero.   
 
For instance I would like this file:  
contig1, 0, 0, 0, 0  
contig2, 1, 3, 5, 0  
contig3, 0, 0, 0, 0  
contig4, 0, 5, 6, 7  
 
To become this file:  
contig2, 1, 3, 5,0 ... (17 Replies)





Discussion started by: mouchkam



17 Replies








7. Shell Programming and Scripting






 Awk, appending a number in the first column of a row with a condition




Hi everyone, 
 
I have a data file in which the data is stored in event blocks. What I would like to get is that the same file with every data row starting with the number of event block. So here is two event blocks from my file: 
 
 
<event> 
       -2   -1    0    0    0  501  0.00000000000E+00 
... (2 Replies)





Discussion started by: hayreter



2 Replies








8. Shell Programming and Scripting






 awk split columns to row after N number of column




I want to split this with every 5 or 50 depend on  how much data the file will have. And remove the comma on the end 
 
Source file will have  
 
001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C 
 
 
Need Output from every 5 tab and remove the comma from end of each row 
 
... (4 Replies)





Discussion started by: ranjancom2000



4 Replies








9. UNIX for Beginners Questions & Answers






 Select and copy .csv files based on row and column number




Dear UNIX experts, 
 
I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum. 
 
I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains... (8 Replies)





Discussion started by: rcsapo



8 Replies








10. UNIX for Beginners Questions & Answers






 Print a row with the max number in a column




Hello, 
 
 
I have this table: 
 
chr1_16857_17742         -        chr1    17369   17436   "ENST00000619216.1";    "MIR6859-1";    -        67 
chr1_16857_17742         -        chr1    14404   29570   "ENST00000488147.1";    "WASH7P";       -        885 
chr1_16857_18061        -        chr1   ... (5 Replies)





Discussion started by: coppuca



5 Replies












    

       

          
        

    

    

      

          
        

    













LEARN ABOUT DEBIAN



split








SPLIT(1)							   User Commands							  SPLIT(1)

NAME

       split - split a file into pieces

SYNOPSIS

       split [OPTION]... [INPUT [PREFIX]]

DESCRIPTION

       Output  fixed-size  pieces  of  INPUT to PREFIXaa, PREFIXab, ...; default size is 1000 lines, and default PREFIX is `x'.  With no INPUT, or
       when INPUT is -, read standard input.

       Mandatory arguments to long options are mandatory for short options too.

       -a, --suffix-length=N
	      use suffixes of length N (default 2)

       -b, --bytes=SIZE
	      put SIZE bytes per output file

       -C, --line-bytes=SIZE
	      put at most SIZE bytes of lines per output file

       -d, --numeric-suffixes
	      use numeric suffixes instead of alphabetic

       -e, --elide-empty-files
	      do not generate empty output files with `-n'

       --filter=COMMAND
	      write to shell COMMAND; file name is $FILE

       -l, --lines=NUMBER
	      put NUMBER lines per output file

       -n, --number=CHUNKS
	      generate CHUNKS output files.  See below

       -u, --unbuffered
	      immediately copy input to output with `-n r/...'

       --verbose
	      print a diagnostic just before each output file is opened

       --help display this help and exit

       --version
	      output version information and exit

       SIZE may be (or may be an integer optionally followed by) one of following: KB 1000, K 1024, MB 1000*1000, M 1024*1024, and so on for G, T,
       P, E, Z, Y.

       CHUNKS  may  be:  N	  split  into  N files based on size of input K/N     output Kth of N to stdout l/N	split into N files without
       splitting lines l/K/N   output Kth of N to stdout without splitting lines r/N	 like `l' but use round robin distribution  r/K/N    like-
       wise but only output Kth of N to stdout

AUTHOR

       Written by Torbjorn Granlund and Richard M. Stallman.

REPORTING BUGS

       Report split bugs to bug-coreutils@gnu.org
       GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
       General help using GNU software: <http://www.gnu.org/gethelp/>
       Report split translation bugs to <http://translationproject.org/team/>

COPYRIGHT

       Copyright (C) 2011 Free Software Foundation, Inc.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The  full  documentation  for split is maintained as a Texinfo manual.  If the info and split programs are properly installed at your site,
       the command

	      info coreutils 'split invocation'

       should give you access to the complete manual.

GNU coreutils 8.12.197-032bb					  September 2011							  SPLIT(1)





















All times are GMT -4. The time now is 06:06 PM.









	






















	
	

Unix & Linux Forums Content Copyright  1993-2022. All Rights Reserved. 

        



Privacy Policy