to find numbers using awk

Tags

shell scripts

Top Forums Shell Programming and Scripting to find numbers using awk

10-02-2007

Registered User

133, 0

Join Date: Jul 2007

Last Activity: 20 July 2013, 1:08 PM EDT

Posts: 133

Thanks Given: 21

Thanked 0 Times in 0 Posts

to find numbers using awk

suppose u have a file

23 33
44 66
55 88

Another file
49
34
49
90

So to find where these numbers lie between in the first file
output shud be while using second file and search for the first file
44 66
-
23 33
44 66
-

cdfd123

View Public Profile for cdfd123

Find all posts by cdfd123

10-02-2007

Moderator

8,825, 1,112

Join Date: Feb 2005

Last Activity: 23 August 2021, 11:26 AM EDT

Location: Foxborough, MA

Posts: 8,825

Thanks Given: 579

Thanked 1,112 Times in 1,003 Posts

nawk -f cdfd.awk file1 file2
cdfd.awk:

Code:

NR==FNR {
    f1[$1]=$2
    next
}
{
   for(i in f1)
      if( $1 >= i && $1 <= f1[i] ) {
        print i, f1[i]
        next
   }
   print "-"
}

vgersh99

View Public Profile for vgersh99

Find all posts by vgersh99

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Script That Find Numbers Less Than 10

We have an existing script called "slots.sh" that prints a few numbers. I want to have another shell script that looks if there is any number from this output that is less than 10. If it does find a number that is less than 10, it then emails to me the output of "slot. sh", if it is equal to 10 or...

2. Programming

RegEx find numbers above 25000

Hello, I am using the Sublime Plugin LogHighlight. I can use RegEx there to highlight some lines in sublime. Now I need to find every line, that has a number of above 25000. the lines look like this: smart_sdl.result: 8947 smart_sdm.result: 8947 smart_sdn.result: 25000 Currently I am...

3. UNIX for Dummies Questions & Answers

Sed/awk to find negative numbers and replace with 1?

Greetings. I have a three column file, and there are some numbers in the second column that are <1. However I need all numbers to be positive, thus need to replace all those numbers with just one. I feel like there must be a simple way to use awk to find these numbers and sed to replace but can't...

4. UNIX for Dummies Questions & Answers

Find common numbers from two very large files using awk or the like

I've got two files that each contain a 16-digit number in positions 1-16. The first file has 63,120 entries all sorted numerically. The second file has 142,479 entries, also sorted numerically. I want to read through each file and output the entries that appear in both. So far I've had no...

5. Shell Programming and Scripting

Find missed numbers

I have a file as follows: 1 3 7 12 78 ... 999998 1000000 I want to find out all numbers not in the file above and put into another file like 2 4 5 6 8 9 10

6. Shell Programming and Scripting

Awk : find progressive increase in numbers

NR_037575 -0.155613339079513 -0.952655362767482 -1.42096466949375 -0.797042023687969 -1.26535133041424 -0.468309306726272 NR_037576 0.59124585320226 0.408702582537126 0.888885242203586 -0.182543270665134 0.297639389001326 0.480182659666459...

7. Shell Programming and Scripting

AWK regex to find only numbers

Hi guys I need to find both negative and positive numbers from the following text file. And i also dont need 0. 0 8 -7 -2268 007 -07 -00 -0a0 0a0 -07a0 7a00 0a0 Can someone please give a regex to filter out the values in red. I tried a few things in awk but it didnt work...

8. Shell Programming and Scripting

find the last word with all numbers?

Hi, I was trying to extract the last word with all numbers using awk. like the below example. I am looking for a pattern using awk. desired result:

9. Shell Programming and Scripting

how to find a sum of multiple numbers

I have a command which returns some numbers as follows: $ls -l ${dbname}.ix* | awk '{print $5 }' 929792 36864 57344 73728 53248 114688 How can I find the sum of those numbers by piping this output into 'awk' or some other editor/command? Thanks a lot -A

10. Shell Programming and Scripting

to find numbers in a string

I writing my script and got stuck in this function. Can someone help me? I need to extract out the numbers inside a string. Ex: INPUT -> OUTPUT abcdef123 -> 123 abc123def -> 123 123abcdef -> 123 a123bc45d -> 123 45 abcdefghi -> -1 Thank you!

Shell Programming and Scripting