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

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 SUSE

record

record(1)						      General Commands Manual							 record(1)

NAME

       record - records *.wav files

SYNOPSIS

       record [ options ]

DESCRIPTION

       record records *.wav files in CD quality (i.e. 44100 Hz, 16bit, stereo).  It has a input level meter, which might be useful for sound trou-
       ble shooting (check if the mixer settings ok for recording from the TV card etc.)

OPTIONS

       -h     display help text

       -o file
	      basename for the output file(s), a number and the .wav extension are added by record.  Default is "record".

       -i dev mixer control.  This should be the one where you can adjust the record level for your audio source.  Default is "line".	"mic"  and
	      "igain" are good candidates too.	Best way to figure is to start your favorite mixer tool and check out which one works ...

       -m dev set mixer device.  Default is "/dev/mixer".

       -d dev set audio device.  Default is "/dev/dsp".

       -r rate
	      set sample rate.	Default is 44100.

       -p sec peak  seconds  (number  of  seconds which should be scanned for the volume maximum).  This affects both peak level display and level
	      triggered recording (see below).	Default is 1.5 seconds.

       record can also be used non-interactive:

       -c     enable console (non-interactive) mode.

       -v     be verbose (console mode only).

       -t mm:ss
	      Limit the record time (console mode only).  By default record records until stopped by a signal (by typing ^C for example).

       -s size
	      Limit the file size (console mode only).	record will continue with a new file once the limit is reached.

       -n num Limit the file count (console mode only).  record will stop recording after num files.

       -l     Enable level triggered recording (console mode only) with the default trigger level (1000).

       -L level
	      Enable level triggered recording with the specified trigger level.

       If level triggered recording is active, record will start and stop recording depending on the signal strength.  Recording will  be  started
       if  the signal strength is above the trigger level (1000/32768 => around 3%).  Recording will be stopped if the signal is below the trigger
       level for some time (1.5 seconds by default, the -p switch changes this).

AUTHOR

       Gerd Knorr <kraxel@bytesex.org>

								  (c) Gerd Knorr							 record(1)