two files.say a and b.both have long columns.i wanna match the column fron 1st file w Post: 302248214

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get columns from another file for match in col 2 in 1st file

Hi, My first file has 592155 9 rs16916098 1 592156 19 rs7249604 1 592157 4 rs885156 1 592158 5 rs350067 12nd file has 9 rs16916098 0 113228129 2 4 19 rs7249604 0 58709070 4 2 2 rs17042833 0 113558750 4 2...

2. UNIX for Dummies Questions & Answers

How to match 2 columns where one column has data as a range

Hi, I have a query about joining files using data ranges. Example files below - I want to join file1 to file2 with matches where file1 column 1 is equal to file2 column1, and file1 column 2 is within the range of file2 columns 3 and 4. I would like rows which don't match to be printed too. ...

3. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Hi, I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines). ################################# huge_file.txt a a ab b ################################## small_file.txt a 1.5 b 2.5 ab ...

4. UNIX for Dummies Questions & Answers

Comparing the 2nd column in two different files and printing corresponding 9th columns in new file

Dear Gurus, I am very new to UNIX. I appreciate your help to manage my files. I have 16 files with equal number of columns in it. Each file has 9 columns separated by space. I need to compare the values in the second column of first file and obtain the corresponding value in the 9th column...

5. UNIX for Dummies Questions & Answers

How to match 2 columns where one column has data as a range - extended

Dear all, there is a nice solution for a text merge where the second file has only variables with a numeric range ( sorry, cannot post URL + thread is closed ). The real world is however more complicated than in the earlier example. file1 A 1 A 2 A 3 B 1 B 2 B 3 B 4 C 1 C 2 C 3 C...

6. UNIX for Dummies Questions & Answers

How to generate one long column by merging two separate two columns in a single file?

Dear all, I have a simple question. I have a file like below (separated by tab): col1 col2 col3 col4 col5 col6 col7 21 66745 rs1234 21 rs5678 23334 0.89 21 66745 rs2334 21 rs9978 23334 0.89 21 66745 ...

7. Shell Programming and Scripting

Difference between 2 files, one with 1 column and 2nd file with multiple columns

Hi, I need to find the difference between 2 files in unix and write the result in the new file File1: A B File2: X 123 hajkd Y 345 adjfka A 123 djafjhd B 678 dsndjks Output file: X 123 hajkd Y 345 adjfka Thanks.

8. Shell Programming and Scripting

Match first two columns and calculate percent of average in third column

I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results. awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file...

9. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def....

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am...

LEARN ABOUT SUSE

finance::quote::yahoo::nz

Finance::Quote::Yahoo::NZ(3)				User Contributed Perl Documentation			      Finance::Quote::Yahoo::NZ(3)

NAME

       Finance::Quote::Yahoo::NZ - Fetch nzn stock quotes via Yahoo.

SYNOPSIS

	   use Finance::Quote;
	   my $q = Finance::Quote->new;

	   my %info = $q->fetch("yahoo_nz","DPC"); # Use this module only.
	   my %info = $q->fetch("nz","DPC"); # Failover with other methods.

DESCRIPTION

       This module allows information to be fetched from Yahoo about stocks traded on the New Zealand Stock Exchange.  Information about indexes
       is not available through this module.

       This module is loaded by default on a Finance::Quote object, although it can be explicitly loaded by passing the argument "Yahoo::nz" to
       Finance::Quote->new().

       This module provides only the "yahoo_nz" fetch methods. The author (stephen@vital.org.nz) will write a module to access the NZX site if
       asked nicely.

       Information obtained via this module is governed by Yahoo's terms and conditions, see http://au.finance.yahoo.com/ for more details.

LABELS RETURNED

       This module returns all the standard labels (where available) provided by Yahoo, as well as the currency label.	See
       Finance::Quote::Yahoo::Base for more information.

SEE ALSO

       Yahoo Australia, http://au.finance.yahoo.com/

       Finance::Quote::Yahoo::Base

perl v5.12.1							    2009-10-05					      Finance::Quote::Yahoo::NZ(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get columns from another file for match in col 2 in 1st file

Discussion started by: genehunter

2. UNIX for Dummies Questions & Answers

How to match 2 columns where one column has data as a range

Discussion started by: auburn

3. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Discussion started by: AshwaniSharma09

4. UNIX for Dummies Questions & Answers

Comparing the 2nd column in two different files and printing corresponding 9th columns in new file

Discussion started by: Unilearn