Sponsored Content
Top Forums Shell Programming and Scripting Search values between ranges in File1 within File2 Post 302282530 by Franklin52 on Saturday 31st of January 2009 02:32:19 PM
Old 01-31-2009
Another one with awk, assuming you have only numbers in the second file, otherwise, replace $0 in the if statement with the desired field:

Code:
awk 'NR==FNR{a[++i]=$1;b[i]=$2;next}
{ for(j=1;j<=i;j++) {
    if($0>=a[j] && $0<=b[j]) {print;break}
  }
}' file1 file2

Regards
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read each word from File1 and search each file in file2

file1: has all words to be searched. 100007 200999 299997 File2: has all file names to be searched. C:\search1.txt C:\search2.txt C:\search3.txt C:\search4.txt Outfile: should have all found lines. Logic: Read each word in file1 and search each file in the list of File2; if the... (8 Replies)
Discussion started by: clem2610
8 Replies

2. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the... (2 Replies)
Discussion started by: Bubnoff
2 Replies

3. Shell Programming and Scripting

Search & replace fields from file1 to file2

hi, I have two xml files with the name source.xml and tobe_replaced.xml. Sample data: source.xml contains: <?xml version="1.0"?> <product description="prod1" product_info="some/info"> <product description="prod2" product_info="xyz/allinfo"> <product description="abc/partialinfo"... (2 Replies)
Discussion started by: dragon.1431
2 Replies

4. Shell Programming and Scripting

Get values from different columns from file2 when match values of file1

Hi everyone, I have file1 and file2 comma separated both. file1 is: Header1,Header2,Header3,Header4,Header5,Header6,Header7,Header8,Header9,Header10 Code7,,,,,,,,, Code5,,,,,,,,, Code3,,,,,,,,, Code9,,,,,,,,, Code2,,,,,,,,,file2... (17 Replies)
Discussion started by: cgkmal
17 Replies

5. Shell Programming and Scripting

Remove lines in file1 with values from file2

Hello, I have two data files: file1 12345 aa bbb cccc 98765 qq www uuuu 76543 pp rrr bbbbb 34567 nn ccc sssss 87654 qq ppp rrrrr file2 98765 34567 I need to remove the lines from file1 if the first field contains a value that appears in file2: output 12345 aa bbb cccc 76543 pp... (2 Replies)
Discussion started by: palex
2 Replies

6. Shell Programming and Scripting

search from file1 and replace into file2

I have 2 files: file1.txt: 1|15|XXXXXX||9630716||0096000||30/04/2012|E|O|X||||20120525135617-30.04.2012|PAT66OLM|STA||||00001|STA_0096000_YYYPPPXTMEX00_20120525135617_02_P.pdf|... (2 Replies)
Discussion started by: pparthiv
2 Replies

7. UNIX for Dummies Questions & Answers

if matching strings in file1 and file2, add column from file1 to file2

I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

8. Shell Programming and Scripting

Search within file1 numbers from list in file2

Hello to all, I hope somebody could help me with this: I have this File1 (real has 5 million of lines): Number Category --------------- -------------------------------------- 8734060355 3 8734060356 ... (6 Replies)
Discussion started by: Ophiuchus
6 Replies

9. Shell Programming and Scripting

awk to search field2 in file2 using range of fields file1 and using match to another field in file1

I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited. I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range... (6 Replies)
Discussion started by: cmccabe
6 Replies

10. Shell Programming and Scripting

Mapping the values of ids of two columns of file1 from file2

I have of two space separated files: ==> File1 <== PT|np_496075.1 st|K92748.1 st|K89648.1 PT|np_001300561.1 PT|np_497284.1 st|K90752.1 st|K90279.1 PT|np_740775.1 PT|np_497749.1 st|K90752.1 st|K92038.1 PT|np_490856.1 PT|np_497284.1 st|K90752.1 st|K88095.1 PT|np_494764.1 ==> File 2 <==... (2 Replies)
Discussion started by: sammy777888
2 Replies
unidesc(1)						      General Commands Manual							unidesc(1)

NAME
unidesc - Describe the contents of a Unicode text file SYNOPSIS
unidesc ([option flags]) (<file name>) If no input file name is supplied, unidesc reads from the standard input. DESCRIPTION
unidesc describes the content of a Unicode text file by reporting the character ranges to which different portions of the text belong. The ranges reported include both official Unicode ranges and the constructed language ranges within the Private Use Areas registered with the Conscript Unicode Registry (http://www.evertype.com/standards/csur/). For each range of characters, unidesc prints the character or byte offset of the beginning of the range, the character or byte offset of the end of the range, and the name of the range. Offsets start from 0. Since the ASCII digits, punctuation, and whitespace characters are frequently used by other writing systems, by default these characters are treated as neutral, that is, as not belonging exclusively to any particular character range. These characters are treated as belonging to the range of whatever characters precede them. If the input begins with neutral characters, they are treated as belonging to the range of whatever characters follow them. If the file consists entirely of neutral characters, the range is identified as Neutral followed by Basic Latin in square brackets. A magic number identifying the Unicode encoding is not part of the Unicode standard, so pure Unicode files do not contain a magic number. However, informal conventions have arisen for this purpose. If the command line flag -m is given, unidesc will attempt to identify the Unicode subtype by examining the first few bytes of the input. If the input is identified as one of the two acceptable types, UTF-8 or native order UTF-32, it will then proceed to describe the contents of the input. Otherwise, it will report what it has learned and exit. Note that if the file does contain a magic number, you must use the -m flag. Without this flag unidesc assumes that the input consists of pure Unicode with the character data beginning immediately. It will therefore be thrown off by the magic number. By default, input is expected to be UTF-8. Native order UTF-32 is also acceptable. UTF-32 may be specified via the command line flag -u or, if the command line flag -m is given, via the magic number. COMMAND LINE FLAGS
-b Give file offsets in bytes rather than characters. -d Treat the ASCII digits as belonging exclusively to the Basic Latin range. -h Print usage information. -L List the Unicode ranges alphabetically. -l List the Unicode ranges by codepoint. -m Check the file's magic number to determine the Unicode subtype. -p Treat ASCII punctuation as belonging exclusively to the Basic Latin range. -r Instead of listing ranges as they are encountered, just list the ranges detected after all input has been read. -u Input is native order UTF-32. -v Print version information. -w Treat ASCII whitespace as belonging exclusively to the Basic Latin range. SEE ALSO
uniname REFERENCES
Unicode Standard, version 5.0 AUTHOR
Bill Poser billposer@alum.mit.edu LICENSE
GNU General Public License June, 2007 unidesc(1)
All times are GMT -4. The time now is 02:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy