Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: matching the coordintaes between 2 files
Top Forums Shell Programming and Scripting matching the coordintaes between 2 files Post 302711413 by anurupa777 on Saturday 6th of October 2012 06:17:01 AM
Old 10-06-2012
Data matching the coordintaes between 2 files
Hii
i have 2 files my file1 contains range of values in col 2 and col3. The second file contains the associated names with respect to that particular range i want to check whether values in first file fall with in the range of values in 2nd file if yes then i want to get the associated name as shown in example

file1

Code:
chr1 10 20
hu1 5 15
hu1 12 19
hu1 36 40
hu1 78 89
hu1 310 865
hu1 80 85

file2

Code:
chr1 1 30 xyz
hu1 35 45 ytg
hu1 70 90 ttf
hu1 300 920 opp

output
Code:
chr1 10 20 xyz 
hu1 5 15 xyz
hu1 12 19 xyz
hu1 36 40 ytg
hu1 78 89 ttf
hu1 310 865 opp
hu1 80 85 ttf

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Matching and combining two files

Hi, How can I match the first two fields of file2 against the first two fields of file1 and where they match combine the two lines. If the name (example-Aidan Rielly) is in file1 but not in file2 then just write the info from file1 to the combined output file. If the name (example-Silvia... (5 Replies)
Discussion started by: p3t3r
5 Replies

2. Shell Programming and Scripting

compare two files and to remove the matching lines on both the files

I have two files and need to compare the two files and to remove the matching lines from both the files (4 Replies)
Discussion started by: shellscripter
4 Replies

3. Shell Programming and Scripting

Matching 2 files

Hi, I am able to modify files (one file) but I have a hard time working with multiple files simultaneously. So I have two files. Basically I want to match two files based on certain columns. Both files are tab-seperated. File1 looks something like this: num1 89 george num4 78 ... (4 Replies)
Discussion started by: kylle345
4 Replies

4. Shell Programming and Scripting

Not matching files

Hi I need to check list of files aganinst a.txt and return those files which are not available in a.txt ls -lrt file1.txt file2.txt file3.txt a.txt ===== file1.txt file2.txt Expecting o/p file3.txt (3 Replies)
Discussion started by: akil
3 Replies

5. Shell Programming and Scripting

Matching 2 files

Hi I am able to match two files (fileA and B) based on the first column using this line. awk -F"/t" 'NR == FNR { A = $0; next } A { print $0 FS A }' However I now need to match the two files (files A and B) based on two columns. On top of that, for those that dont match, I want it to... (1 Reply)
Discussion started by: phil_heath
1 Replies

6. Shell Programming and Scripting

Delete all files if another files in the same directory has a matching occurence of a specific word

Hello, I have several files in a specific directory. A specific string in one file can occur in another files. If this string is in other files. Then all the files in which this string occured should be deleted and only 1 file should remain with the string. Example. file1 ShortName "Blue... (2 Replies)
Discussion started by: premier_de
2 Replies

7. UNIX for Dummies Questions & Answers

Matching corresponding columns in two different files

Hi to all, I have two separated files: FILE1 "V1" "V2" "V3" Mary James Nicole Robert Francisco Sophie Nancy Antony Matt Josephine Louise Rose Mark Simon Charles FILE2 "V1" "V2" "V3"... (2 Replies)
Discussion started by: eleonoral
2 Replies

8. Shell Programming and Scripting

matching two files

Hello, I need to match one file with another. The best would be to give an example. File 1 A 1 B 2 C 3 D 4 E 5 F 6 File 2 A 5 6 2 B 3 2 1 F 4 2 9 (1 Reply)
Discussion started by: gisele_l
1 Replies

9. Shell Programming and Scripting

Matching two files per column

Hi, I hope somebody can help me with this problem, since I would like to solve this problem using awk, but im not experienced enough with this. I have two files which i want to match, and output the matching column name and row number. One file contains 4 columns like this: FILE1: a ... (6 Replies)
Discussion started by: Jenna.bos
6 Replies

10. Shell Programming and Scripting

Delete all files if another files in the same directory has a matching occurrence of a specific word

he following are the files available in my directory RSK_123_20141113_031500.txt RSK_123_20141113_081500.txt RSK_126_20141113_041500.txt RSK_126_20141113_081800.txt RSK_128_20141113_091600.txt Here, "RSK" is file prefix and 123 is a code name and rest is just timestamp of the file when its... (7 Replies)
Discussion started by: kridhick
7 Replies

LEARN ABOUT OSX

locale::codes::langvar

Locale::Codes::LangVar(3pm)				 Perl Programmers Reference Guide			       Locale::Codes::LangVar(3pm)

NAME

       Locale::Codes::LangVar - standard codes for language variation identification

SYNOPSIS

	  use Locale::Codes::LangVar;

	  $lvar = code2langvar('acm');		       # $lvar gets 'Mesopotamian Arabic'
	  $code = langvar2code('Mesopotamian Arabic'); # $code gets 'acm'

	  @codes   = all_langvar_codes();
	  @names   = all_langvar_names();

DESCRIPTION

       The "Locale::Codes::LangVar" module provides access to standard codes used for identifying language variations, such as those as defined in
       the IANA language registry.

       Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default IANA language
       registry codes will be used.

SUPPORTED CODE SETS

       There are several different code sets you can use for identifying language variations. A code set may be specified using either a name, or
       a constant that is automatically exported by this module.

       For example, the two are equivalent:

	  $lvar = code2langvar('en','alpha-2');
	  $lvar = code2langvar('en',LOCALE_CODE_ALPHA_2);

       The codesets currently supported are:

       alpha
	   This is the set of alphanumeric codes from the IANA language registry, such as 'arevela' for Eastern Armenian.

	   This code set is identified with the symbol "LOCALE_LANGVAR_ALPHA".

	   This is the default code set.

ROUTINES

       code2langvar ( CODE [,CODESET] )
       langvar2code ( NAME [,CODESET] )
       langvar_code2code ( CODE ,CODESET ,CODESET2 )
       all_langvar_codes ( [CODESET] )
       all_langvar_names ( [CODESET] )
       Locale::Codes::LangVar::rename_langvar  ( CODE ,NEW_NAME [,CODESET] )
       Locale::Codes::LangVar::add_langvar  ( CODE ,NAME [,CODESET] )
       Locale::Codes::LangVar::delete_langvar  ( CODE [,CODESET] )
       Locale::Codes::LangVar::add_langvar_alias  ( NAME ,NEW_NAME )
       Locale::Codes::LangVar::delete_langvar_alias  ( NAME )
       Locale::Codes::LangVar::rename_langvar_code  ( CODE ,NEW_CODE [,CODESET] )
       Locale::Codes::LangVar::add_langvar_code_alias  ( CODE ,NEW_CODE [,CODESET] )
       Locale::Codes::LangVar::delete_langvar_code_alias  ( CODE [,CODESET] )
	   These routines are all documented in the Locale::Codes::API man page.

SEE ALSO

       Locale::Codes
	   The Locale-Codes distribution.

       Locale::Codes::API
	   The list of functions supported by this module.

       http://www.iana.org/assignments/language-subtag-registry
	   The IANA language subtag registry.

AUTHOR

       See Locale::Codes for full author history.

       Currently maintained by Sullivan Beck (sbeck@cpan.org).

COPYRIGHT

	  Copyright (c) 2011-2012 Sullivan Beck

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.16.2							    2012-10-11					       Locale::Codes::LangVar(3pm)
All times are GMT -4. The time now is 03:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy