Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Comparing all lines in a column with another is condition is met
Top Forums Shell Programming and Scripting Comparing all lines in a column with another is condition is met Post 302825541 by amits22 on Monday 24th of June 2013 02:21:22 PM
Old 06-24-2013
Comparing all lines in a column with another is condition is met
Sorry for this noob question,
I have file with 4 columns like where columns 2 and 4 have numbers

Code:
a 55  k 3
b 59 l 3
c 79 m 277
d 255 n 277
e 257 o 267
f 267 p 287
g 290  q 287
h 290 r 287
i 310 s 900

now i want to select only those rows, where values in column 4 are greater than those in column 2 in a range of 1 to 30.
so the out put should be like

Code:
m 277
n 277
o 267
p 287
q 287
r 287

and those which exactly have a difference of 10
Code:
m 277
n 277
o 267

I will appreciate any help. I hope this can be done with awk.
Thanks
Last edited by amits22; 06-24-2013 at 09:08 PM.. Reason: Changed HTML tags to CODE tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Send email to user when condition met

Hi all, I plan to write a shell script to inform users on their task when certain condition met. example: If a then email user on action a else email user on action b. I'm pretty new in scripting, appreciate any suggestions. Thanks. (4 Replies)
Discussion started by: *Jess*
4 Replies

2. Shell Programming and Scripting

How to break a loop if condition is met

I am having trouble figuring this code I want to grep a text from a file and if it match certain text it break out of the loop or it should continue searching for the text Here is what I have written but it isn't working while true f=`grep 'END OF STATUS REPORT' filename` do if ... (9 Replies)
Discussion started by: Issemael
9 Replies

3. Shell Programming and Scripting

sed/awk to update 1st column if condition met

Hi, I am trying to update the 1st column of a file but only if it contains a char here is an example of my file 1111aaa 9999 textaaa 22222bbb 9999 textbbb 3333 9999 textccc 444ddd 9999 textddd i would like the output to remove any characters () from... (5 Replies)
Discussion started by: plennon
5 Replies

4. Shell Programming and Scripting

do nothing if condition is not met but not exit

Hello all, I created the below script....and it seemed to be working fine. My problem is i want the script to ignore rest of the things if my condition is not met but do not exit.... #!/bin/ksh ########################### ########################### # Set name of the listener, this... (2 Replies)
Discussion started by: abdul.irfan2
2 Replies

5. UNIX for Advanced & Expert Users

While loop only if a condition is met

All, I wrote the following section of code (which logically in PHP would of worked): tmpPATH=${1} tmpTAG=${2} if then while read tmpTAG tmpPATH do fi echo $tmpTAG echo $tmpPATH if then done < ./config.cfg fi (4 Replies)
Discussion started by: Cranie
4 Replies

6. Shell Programming and Scripting

Delete if condition met in a column

i have a table like this: id, senderNumber, blacklist ----------------------------- 1 0835636326 Y 2 0373562343 Y 3 0273646833 Y and I want to delete automatically if a new inserted row on another table consist anything on senderNumber column above using a BASH Script I... (9 Replies)
Discussion started by: jazzyzha
9 Replies

7. Shell Programming and Scripting

Getting the records once condition met

Hi All, Seeking for your assistance to get the records once the $2 met the condition. Ex. file 1.txt 123455,10-Aug-2020 07:33:37 AM,2335235,1323534,12343 123232,11-Aug-2015 08:33:37 PM,4234324,1321432,34364 Output: 123455,10-Aug-2020 07:33:37 AM,2335235,1323534,12343 What i did... (5 Replies)
Discussion started by: znesotomayor
5 Replies

8. Shell Programming and Scripting

Need help on how to append on the filename when condition met.

Hi All, Seeking for your assistance on how to append the specific string when $3 condion met. ex. file1.txt ar0050046b16,5,888,0,0,0,0.00,0.00,0.00,0.00,25689.55 ar0050046b16,5,0,0,0,0,0.00,0.00,0.00,0.00,25689.55 ar0050046b16,5,0,0,0,0,0.00,0.00,0.00,0.00,25689.55 expected output:... (5 Replies)
Discussion started by: znesotomayor
5 Replies

9. Shell Programming and Scripting

Add another condition to bash for when not met

In the below I can not seem to add a line that will add Not low if the statement in bold is not true or meet. I guess when the first if statement is true/meet then print low, otherwise print Not low in $(NF + 1). I am not sure how to correctly add this. Thank you :). if(low <= $2 && $2 <=... (5 Replies)
Discussion started by: cmccabe
5 Replies

10. UNIX for Beginners Questions & Answers

awk - print when condition is met

I have a file.txt containing the following: Query= HWI-ST863:386:C5Y8UACXX:3:2302:16454:89688 1:N:0:ACACGAAT Length=100 Score E Sequences producing significant alignments: (Bits) Value ... (2 Replies)
Discussion started by: tons92
2 Replies

LEARN ABOUT OPENSOLARIS

iconv_koi8-r

iconv_koi8-r(5)                                         Standards, Environments, and Macros                                        iconv_koi8-r(5)

NAME

       iconv_koi8-r - code set conversion tables for KOI8-R

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |                     Code Set Conversions Supported                      |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output      |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic     |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |MS 1251       |win5    | Windows Cyrillic        |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |Mac Cyrillic  |mac     | Macintosh Cyrillic      |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   KOI8-R to ISO 8859-5
       For the conversion of KOI8-R to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |  ISO 8859-5    |    KOI8-R      |  ISO 8859-5   |
       |24             | 4              |320             |337            |
       |241            | 362            |321             |357            |
       |242            | 363            |322             |340            |
       |243            | 361            |323             |341            |
       |244            | 364            |324             |342            |
       |245            | 365            |325             |343            |
       |246            | 366            |327             |322            |
       |247            | 367            |330             |354            |
       |250            | 370            |331             |353            |
       |251            | 371            |332             |327            |
       |252            | 372            |333             |350            |
       |253            | 373            |334             |355            |
       |254            | 374            |335             |351            |
       |256            | 376            |336             |347            |
       |257            | 377            |337             |352            |
       |260            | 360            |340             |316            |
       |261            | 242            |341             |260            |
       |262            | 243            |342             |261            |
       |263            | 241            |343             |306            |
       |264            | 244            |344             |264            |
       |265            | 245            |345             |265            |
       |266            | 246            |346             |304            |
       |267            | 247            |347             |263            |
       |270            | 250            |350             |305            |
       |271            | 251            |351             |270            |
       |272            | 252            |352             |271            |
       |273            | 253            |353             |272            |
       |274            | 254            |354             |273            |
       |275            | 255            |355             |274            |
       |276            | 256            |356             |275            |
       |277            | 257            |357             |276            |
       |300            | 356            |360             |277            |
       |301            | 320            |361             |317            |
       |302            | 321            |362             |300            |
       |303            | 346            |363             |301            |
       |304            | 324            |364             |302            |
       |305            | 325            |365             |303            |
       |306            | 344            |366             |266            |
       |307            | 323            |367             |262            |
       |310            | 345            |370             |314            |
       |311            | 330            |371             |313            |
       |312            | 331            |372             |267            |
       |313            | 332            |373             |310            |
       |314            | 333            |374             |315            |
       |315            | 334            |375             |311            |
       |316            | 335            |376             |307            |
       |317            | 336            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to PC Cyrillic
       For the conversion of KOI8-R to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |  PC Cyrillic   |    KOI8-R      | PC Cyrillic   |
       |24             | 4              |333             |350            |
       |200-242        | 40             |334             |355            |
       |243            | 361            |335             |351            |
       |244-254        | 40             |336             |347            |
       |255            | 260            |337             |352            |
       |256-262        | 40             |340             |236            |
       |263            | 360            |341             |200            |
       |264-274        | 40             |342             |201            |
       |275            | 260            |343             |226            |
       |276-277        | 40             |344             |204            |
       |300            | 356            |345             |205            |
       |301            | 240            |346             |224            |
       |302            | 241            |347             |203            |
       |303            | 346            |350             |225            |
       |304            | 244            |351             |210            |
       |305            | 245            |352             |211            |
       |306            | 344            |353             |212            |
       |307            | 243            |354             |213            |
       |310            | 345            |355             |214            |
       |311            | 250            |356             |215            |
       |312            | 251            |357             |216            |
       |313            | 252            |360             |217            |
       |314            | 253            |361             |237            |
       |315            | 254            |362             |220            |
       |316            | 255            |363             |221            |
       |317            | 256            |364             |222            |
       |320            | 257            |365             |223            |
       |321            | 357            |366             |206            |
       |322            | 340            |367             |202            |
       |323            | 341            |370             |234            |
       |324            | 342            |371             |233            |
       |325            | 343            |372             |207            |
       |326            | 246            |373             |230            |
       |327            | 242            |374             |235            |
       |330            | 354            |375             |231            |
       |331            | 353            |376             |227            |
       |332            | 247            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to MS 1251
       For the conversion of KOI8-R to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |    MS 1251     |    KOI8-R      |   MS 1251     |
       |24             | 4              |317             |356            |
       |200-237        | 40             |320             |357            |
       |241            | 220            |321             |377            |
       |242            | 203            |322             |360            |
       |243            | 270            |323             |361            |
       |244            | 272            |324             |362            |
       |245            | 276            |325             |363            |
       |246            | 263            |326             |346            |
       |247            | 277            |327             |342            |
       |250            | 274            |330             |374            |
       |251            | 232            |331             |373            |
       |252            | 234            |332             |347            |
       |253            | 236            |333             |370            |
       |254            | 235            |334             |375            |
       |255            | 210            |335             |371            |
       |256            | 242            |336             |367            |
       |257            | 237            |337             |372            |
       |260            | 271            |340             |336            |
       |261            | 200            |341             |300            |
       |262            | 201            |342             |301            |
       |263            | 250            |343             |326            |
       |264            | 252            |344             |304            |
       |265            | 275            |345             |305            |
       |266            | 262            |346             |324            |
       |267            | 257            |347             |303            |
       |270            | 243            |350             |325            |
       |271            | 212            |351             |310            |
       |272            | 214            |352             |311            |
       |273            | 216            |353             |312            |
       |274            | 215            |354             |313            |
       |275            | 210            |355             |314            |
       |276            | 241            |356             |315            |
       |277            | 217            |357             |316            |
       |300            | 376            |360             |317            |
       |301            | 340            |361             |337            |
       |302            | 341            |362             |320            |
       |303            | 366            |363             |321            |
       |304            | 344            |364             |322            |
       |305            | 345            |365             |323            |
       |306            | 364            |366             |306            |
       |307            | 343            |367             |302            |
       |310            | 365            |370             |334            |
       |311            | 350            |371             |333            |
       |312            | 351            |372             |307            |
       |313            | 352            |373             |330            |
       |314            | 353            |374             |335            |
       |315            | 354            |375             |331            |
       |316            | 355            |376             |327            |
       |376            | 227            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to Mac Cyrillic
       For the conversion of KOI8-R to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     | Mac Cyrillic   |    KOI8-R      | Mac Cyrillic  |
       |24             | 4              |317             |356            |
       |200-237        | 40             |320             |357            |
       |240            | 312            |321             |337            |
       |241            | 254            |322             |360            |
       |242            | 257            |323             |361            |
       |243            | 336            |324             |362            |
       |244            | 271            |325             |363            |
       |245            | 317            |326             |346            |
       |246            | 264            |327             |342            |
       |247            | 273            |330             |374            |
       |250            | 300            |331             |373            |
       |251            | 275            |332             |347            |
       |252            | 277            |333             |370            |
       |253            | 40             |334             |375            |
       |254            | 316            |335             |371            |
       |255            | 40             |336             |367            |
       |256            | 331            |337             |372            |
       |257            | 333            |340             |236            |
       |260            | 334            |341             |200            |
       |261            | 253            |342             |201            |
       |262            | 256            |343             |226            |
       |263            | 335            |344             |204            |
       |264            | 270            |345             |205            |
       |265            | 301            |346             |224            |
       |266            | 247            |347             |203            |
       |267            | 272            |350             |225            |
       |270            | 267            |351             |210            |
       |271            | 274            |352             |211            |
       |272            | 276            |353             |212            |
       |273            | 40             |354             |213            |
       |274            | 315            |355             |214            |
       |275            | 40             |356             |215            |
       |276            | 330            |357             |216            |
       |277            | 332            |360             |217            |
       |300            | 376            |361             |237            |
       |301            | 340            |362             |220            |
       |302            | 341            |363             |221            |
       |303            | 366            |364             |222            |
       |304            | 344            |365             |223            |
       |305            | 345            |366             |206            |
       |306            | 364            |367             |202            |
       |307            | 343            |370             |234            |
       |310            | 365            |371             |233            |
       |311            | 350            |372             |207            |
       |312            | 351            |373             |230            |
       |313            | 352            |374             |235            |
       |314            | 353            |375             |231            |
       |315            | 354            |376             |227            |
       |316            | 355            |                |               |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          18 Apr 1997                                                    iconv_koi8-r(5)
All times are GMT -4. The time now is 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy