how to match fields from different files in PERL Post: 302520791

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match two files and divide fields

I have two files that have the date field in common. I request your help with some script that divide each field value from file1 by the correspond field value of the file2 only when the field date is equal in both files. Thanks in advance ! This is a sample of the files file 1 12/16/2010,...

2. UNIX for Dummies Questions & Answers

Match values from 2 files and append certain fields

Hi, I need help on appending certain field in my file1.txt based on matched patterns in file2.txt using awk or sed. The blue color need to match with one of the data in field $2 in file2.txt. If match, BEGIN and FINISHED value in red will have a new value from field $3 and $4 accordingly. ...

3. Shell Programming and Scripting

Add fields in different files only if some fields between them match

Hi everybody (first time posting here) I have a file1 that looks like > 1,101,0.1,0.1 1,26,0.1,0.1 1,3,0.1,0.1 1,97,0.5,0.5 1,98,8.1,0.218919 1,99,6.2,0.248 2,101,0.1,0.1 2,24,3.1,0.147619 2,25,23.5,0.559524 2,26,34,0.723404with 762 lines.. I have another 'similar' file2 > ...

4. Homework & Coursework Questions

Regular Expression to match files in Perl

Hi Everybody! I need some help with a regular expression in Perl that will match files named messages, but also files named message.1, message.2 and so on. So really I need one that will find messages and messages that might be followed by a period and a digit without matching other files like...

5. Shell Programming and Scripting

awk help: Match data fields from 2 files & output results from both into 1 file

I need to take 2 input files and create 1 output based on matches from each file. I am looking to match field #1 in both files (Userid) and create an output file that will be a combination of fields from both file1 and file2 if there are any differences in the fields 2,3,4,5,or 6. Below is an...

6. Shell Programming and Scripting

awk to print fields that match using conditions and a default value for non-matching in two files

Trying to use awk to match the contents of each line in file1 with $5 in file2. Both files are tab-delimited and there may be a space or special character in the name being matched in file2, for example in file1 the name is BRCA1 but in file2 the name is BRCA 1 or in file1 name is BCR but in file2...

7. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing...

8. UNIX for Beginners Questions & Answers

Match Fields between two files, print portions of each file together when matched in ([g]awk)'

I've written an awk script to compare two fields in two different files and then print portions of each file on the same line when matched. It works reasonably well, but every now and again, I notice some errors and cannot seem to figure out what the issue may be and am turning to you for help. ...

9. UNIX for Beginners Questions & Answers

awk match two fields in two files

Hi, I have two TEST files t.xyz and a.xyz which have three columns each. a.xyz have more rows than t.xyz. I will like to output rows at which $1 and $2 of t.xyz match $1 and $2 of a.xyz. Total number of output rows should be equal to that of t.xyz. It works fine, but when I apply it to large...

10. Shell Programming and Scripting

Matching two fields in two csv files, create new file and append match

I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file Command that Ive been using...

LEARN ABOUT DEBIAN

asp-perl

ASP-PERL(1p)						User Contributed Perl Documentation					      ASP-PERL(1p)

NAME

       asp-perl - Apache::ASP CGI and command line script processor

SYNOPSIS

       asp-perl [-hsdb] [-f asp.conf] [-o directory] file1 @arguments file2 @arguments ...

	   -h  Help you are getting now!
	   -f  Specify an alternate configuration file other than ./asp.conf
	   -s  Setup $Session and $Application state for script.
	   -d  Set to debug code upon errors.
	   -b  Only return body of document, no headers.
	   -o  Output directory, writes to files there instead of STDOUT
	   -p  GlobalPackage config, what perl package are the scripts compiled in.

DESCRIPTION

       This program will run Apache::ASP scripts from the command line.  Each file that is specified will be run, and the $Request->QueryString()
       and $Request->Form() data will be initialized by the @arguments following the script file name.

       The @arguments will be written as space separated words, and will be initialized as an associate array where %arguments = @arguments.  As
       an example:

	asp-perl file.asp key1 value1 key2 value2

       would be similar to calling the file.asp in a web environment like

	/file.asp?key1=value1&key2=value2

       The asp.conf script will be read from the current directory for parameters that would be set with PerlSetVar normally under mod_perl.  For
       more information on how to configure the asp.conf file, please see < http://www.apache-asp.org/cgi.html >

SEE ALSO

       perldoc Apache::ASP, and also http://www.apache-asp.org

COPYRIGHT

       Copyright 1998-2004 Joshua Chamas, Chamas Enterprises Inc.

       This program is distributed under the GPL.  Please see the LICENSE file in the Apache::ASP distribution for more information.

perl v5.14.2							    2011-08-15							      ASP-PERL(1p)