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 302402219 by Nila on Tuesday 9th of March 2010 07:30:53 AM
Old 03-09-2010
Actually,you have done some mistakes in your script.If you are getting more than one line.You have to store those inputs in file.You split the line content into different columns.After that,you're just comparing $strike_price value is greater than 10000.That comparison itself problem.You didn't assign any value to $strike_price variable and you have to go to next line if the value is less than 10000.So that should be less than 10000 not greater than 10000.I changed the above changes in the following code.You try this,

Code:
while(<DATA>) {
 my ( $col1, $col2, $col3, $col4, $col5, $col6, $col7 ) = split ( /\s+/ ); # split current line where you at least one space or tab...
 next if $col3 < 10000;
 print STDOUT $_; # print current line. We did not chomp it, so no need for an extra \n.
}
__DATA__
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

 

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 OPENSOLARIS

dr

dr(7d)								      Devices								    dr(7d)

NAME

       dr, drmach, ngdr, ngdrmach - Sun Enterprise 10000  dynamic reconfiguration driver

SYNOPSIS

       dr

       drmach

       ngdr

       ngdrmach

DESCRIPTION

       The  dynamic reconfiguration (DR) driver consists of a platform-independent driver and a platform-specific module. The DR driver uses stan-
       dard features of the Solaris operating environment whenever possible to control DR operations and calls the  platform  specific	module	as
       needed. The DR driver creates minor nodes in the file system that serve as attachment points for DR operations.

       The  DR	driver provides a pseudo-driver interface to sequence attach and detach operations on system boards using file system entry points
       referred to as "attachment points." The attachment point form depends on the platform.

   Sun Enterprise 10000 Server
       On the Sun Enterprise 10000 server, the DR driver consists of a platform-independent driver (ngdr) and a  platform-specific  module  (ngdr-
       mach).

       The  domain  configuration server (DCS) accepts DR requests from the system services processor (SSP) and uses the libcfgadm(3LIB) interface
       to initiate the DR operation. After the operation is performed, the results are returned to the SSP. For more information about the DCS	on
       the Sun Enterprise 10000, refer to the dcs(1M) man page and the Sun Enterprise 10000 Dynamic Reconfiguration User Guide.

       The DR driver creates physical attachment points for system board slots that takes the following form:

	 /devices/pseudo/ngdr@0:SBx

       Where x represents the slot number (0 to 15) for a particular board.

       The  cfgadm_sbd(1M)  plugin  creates  dynamic  attachment  points that refer to components on system boards, including CPUs, memory, or I/O
       devices. Refer to the cfgadm_sbd(1M) man page for more details.

SEE ALSO

       cfgadm_sbd(1M), ioctl(2), libcfgadm(3LIB)

       Sun Enterprise 10000 Dynamic Reconfiguration User Guide

SunOS 5.11							    29 Sep 2003 							    dr(7d)
All times are GMT -4. The time now is 10:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy