Add fields in different files only if some fields between them match Post: 302527847

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

how to match fields from different files in PERL

4. 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...

5. Shell Programming and Scripting

awk partial string match and add specific fields

Trying to combine strings that are a partial match to another in $1 (usually below it). If a match is found than the $2 value is added to the $2 value of the match and the $3 value is added to the $3 value of the match. I am not sure how to do this and need some expert help. Thank you :). file ...

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. 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. ...

8. 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...

9. 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...

10. UNIX for Beginners Questions & Answers

Is there a UNIX command that can compare fields of files with differing number of fields?

Hi, Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account. $ head -500 x.txt y.txt ==> x.txt <== TEST01 APP_USER_PROFILE USER03 APP_USER_PROFILE TEST02 APP_USER_EXP_PROFILE TEST04 APP_USER_PROFILE USER01 ...

LEARN ABOUT MINIX

diff

DIFF(1) 						      General Commands Manual							   DIFF(1)

NAME

       diff - print differences between two files

SYNOPSIS

       diff   [-c | -e | -C n] [-br]file1 file2

OPTIONS

       -C n   Produce output that contains n lines of context

       -b     Ignore white space when comparing

       -c     Produce output that contains three lines of context

       -e     Produce an ed-script to convert file1 into file2

       -r     Apply diff recursively to files and directories of

EXAMPLES

       diff file1 file2    # Print differences between 2 files

       diff -C 0 file1 file2
			   # Same as above

       diff -C 3 file1 file2
			   # Output three lines of context with every

       diff -c file1 file2 # Same

       diff /etc /dev	   # Compares recursively the directories /etc and /dev

       diff passwd /etc    # Compares ./passwd to /etc/passwd

DESCRIPTION

       the same name, when file1 and file2 are both directories" difference encountered"

       Diff  compares  two files and generates a list of lines telling how the two files differ.  Lines may not be longer than 128 characters.	If
       the two	arguments on the command line are both directories, diff recursively steps through all subdirectories comparing files of the  same
       name.  If  a  file  name is found only in one directory, a diagnostic message is written to stdout. A file that is of either block special,
       character special or FIFO special type, cannot be compared to any other file.  On the other hand, if there is one directory  and  one  file
       given on the command line, diff tries to compare the file with the same name as file in the directory directory.

SEE ALSO

       cdiff(1), cmp(1), comm(1), patch(1).

																	   DIFF(1)