Print matching fields (if they exist) from two text files Post: 302989282

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK Matching Fields and Combining Files

Hello! I am writing a program to run through two large lists of data (~300,000 rows), find where rows in one file match another, and combine them based on matching fields. Due to the large file sizes, I'm guessing AWK will be the most efficient way to do this. Overall, the input and output I'm...

2. Shell Programming and Scripting

comparing two files for matching fields

I am newbie to unix and would please like some help to solve the task below I have two files, file_a.text and file_b.text that I want to evaluate. file_a.text 1698.74 1711.88 6576.25 899.41 3205.63 4187.98 697.35 1551.83 ...

3. Shell Programming and Scripting

Matching multiple fields from two files and then some?

Hi, I am working with two tab-delimited files with multiple columns, formatted as follows: File 1: >chrom 1 100 A G 20 …(10 columns) >chrom 1 104 G C 18 …(10 columns) >chrom 2 28 T C ...

4. UNIX for Advanced & Expert Users

awk print all fields except matching regex

grep -v will exclude matching lines, but I want something that will print all lines but exclude a matching field. The pattern that I want excluded is '/mnt/svn' If there is a better solution than awk I am happy to hear about it, but I would like to see this done in awk as well. I know I can...

5. Shell Programming and Scripting

How to merge two or more fields from two different files where there is non matching column?

Hi, Please excuse for often requesting queries and making R&D, I am trying to work out a possibility where i have two files field separated by pipe and another file containing only one field where there is no matching columns, Could you please advise how to merge two files. $more...

6. Shell Programming and Scripting

awk to combine all matching fields in input but only print line with largest value in specific field

In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited, that are in $1 of gene which is just a single column of text. However only the line with the greatest $9 value in input needs to be printed. So in the example below all the MECP2 and LTBP1...

7. UNIX for Beginners Questions & Answers

Awk: matching multiple fields between 2 files

Hi, I have 2 tab-delimited input files as follows. file1.tab: green A apple red B apple file2.tab: apple - A;Z Objective: Return $1 of file1 if, . $1 of file2 matches $3 of file1 and, . any single element (separated by ";") in $3 of file2 is present in $2 of file1 In order to...

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

9. UNIX for Beginners Questions & Answers

Matching fields between two files, repeated records

In two previous posts (here) and (here), I received help from forum members comparing multiple fields across two files and selectively printing portions of each as output based upon would-be matches using awk. I had been fairly comfortable populating awk arrays with fields and using awk's special...

10. Shell Programming and Scripting

Comparing two files by two matching fields

Long time listener first time poster. Hope someone can advise. I have two files, 1000+ lines in each, two fields in each file. After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those...

LEARN ABOUT DEBIAN

bup-restore

bup-restore(1)						      General Commands Manual						    bup-restore(1)

NAME

       bup-restore - extract files from a backup set

SYNOPSIS

       bup restore [--outdir=outdir] [-v] [-q]

DESCRIPTION

       bup restore extracts files from a backup set (created with bup-save(1)) to the local filesystem.

       The specified paths are of the form /branch/revision/path/to/file.  The components of the path are as follows:

       branch the name of the backup set to restore from; this corresponds to the --name (-n) option to bup save.

       revision
	      the  revision of the backup set to restore.  The revision latest is always the most recent backup on the given branch.  You can dis-
	      cover other revisions using bup ls /branch.

       /path/to/file
	      the original absolute filesystem path to the file you want to restore.  For example, /etc/passwd.

       Note: if the /path/to/file is a directory, bup restore will restore that directory as well as recursively restoring all its contents.

       If /path/to/file is a directory ending in a slash (ie.  /path/to/dir/), bup restore will restore the children of that directory directly to
       the  current directory (or the --outdir).  If the directory does not end in a slash, the children will be restored to a subdirectory of the
       current directory.  See the EXAMPLES section to see how this works.

OPTIONS

       -C, --outdir=outdir
	      create and change to directory outdir before extracting the files.

       -v, --verbose
	      increase log output.  Given once, prints every directory as it is restored; given twice, prints every file and directory.

       -q, --quiet
	      don't show the progress meter.  Normally, is stderr is a tty, a progress display is printed that shows the  total  number  of  files
	      restored.

EXAMPLE

       Create a simple test backup set:

	      $ bup index -u /etc
	      $ bup save -n mybackup /etc/passwd /etc/profile

       Restore just one file:

	      $ bup restore /mybackup/latest/etc/passwd
	      Restoring: 1, done.

	      $ ls -l passwd
	      -rw-r--r-- 1 apenwarr apenwarr 1478 2010-09-08 03:06 passwd

       Restore the whole directory (no trailing slash):

	      $ bup restore -C test1 /mybackup/latest/etc
	      Restoring: 3, done.

	      $ find test1
	      test1
	      test1/etc
	      test1/etc/passwd
	      test1/etc/profile

       Restore the whole directory (trailing slash):

	      $ bup restore -C test2 /mybackup/latest/etc/
	      Restoring: 2, done.

	      $ find test2
	      test2
	      test2/passwd
	      test2/profile

SEE ALSO

       bup-save(1), bup-ftp(1), bup-fuse(1), bup-web(1)

BUP

       Part of the bup(1) suite.

AUTHORS

       Avery Pennarun <apenwarr@gmail.com>.

Bup unknown-															    bup-restore(1)