How can I match values in one file to ranges from another?

by

if the data file sizes are not huge, there is a simpler way

$ join input1 input2 | awk '$5<$4 && $3<$5 {print $2, $5-$3+1}'

B100002 32
B100043 15
B123465 3

More Related Contents:

  1. How to use shell variables in perl command call in a bash shell script?
  2. how to print n words of context while searching text [closed]
  3. What is meaning of defined keyword [closed]
  4. Iterating through a CSV and pulling out the last line of the day for each element
  5. how to check if a number is whole number or contains a decimal
  6. How can i do this in perl, shortcut truthtable [closed]
  7. Failing to install MIME::Base64 using cpan [closed]
  8. Awk – replace coumn 2 in table 1 from coumn 2 in table 2 based on matching data in column 1 (common between tables)
  9. Why can’t Perl find my file that is in ClearCase?
  10. How can I install a CPAN module into a local directory?
  11. How can I use CPAN as a non-root user?
  12. Perl daemonize with child daemons
  13. What’s the difference between a hash and hash reference in Perl?
  14. Multiline search replace with Perl
  15. How can I process options using Perl in -n or -p mode?
  16. Using perl’s `system`
  17. What’s the best way to open and read a file in Perl?
  18. How do I daemonize an arbitrary script in unix?
  19. How can I dynamically include Perl modules without using eval?
  20. How can I store the result of a system command in a Perl variable?
  21. How can I check if a file exists in Perl?
  22. Using Encode::encode with “utf8”
  23. How can I start an interactive console for Perl?
  24. What does =~ do in Perl? [closed]
  25. How to convert letters with accents, umlauts, etc to their ASCII counterparts in Perl?
  26. What does shift() do in Perl?
  27. How can I extract text from a PDF file in Perl?
  28. How do I retrieve the terminal width in Perl?
  29. How to make DateTime::Duration output only in days?
  30. How do I tell CPAN to install all dependencies?

Leave a Comment