Compare 2 columns of files awk Post: 302939326

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to compare 2 files & get only few columns based on a condition related to both files?

Hiiiii friends I have 2 files which contains huge data & few lines of it are as shown below File1: b.dat(which has 21 columns) SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL ISC 1976 8 12 22 32 37.39 36.2942 70.7338...

2. Shell Programming and Scripting

awk compare 2 columns, 2 files, output whole line

Hello, I have not been able to find what I'm looking for via searching the forum. I could use some help with an awk script or one-liner to solve this simple problem. I have two files. If $1 and $2 from file1 match $1 and $2 from file2, print the whole line from file2. Example file1 ...

3. Shell Programming and Scripting

awk compare specific columns from 2 files, print new file

Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3. FILE1 1466 55.27433 14.72050 -2.52E+03 3.00E-01 1.05E+04 2.57E+04 1467 55.27433...

4. Shell Programming and Scripting

Compare Columns of two files

Hi I have file 1 like this and file 2 like this I need to compare column 3 of both files and delete lines in file1 with same column 3 values in two files. So the output is I tried with perl but didnt work. A perl code will be good as I am learning the language, but any other code would...

5. Shell Programming and Scripting

Compare intervals (columns) from two files (awk, grep, Perl?)

Hi dear users, I need to compare numeric columns in two files. These files have the following structure. K.txt (4 columns) A001 chr21 9805831 9846011 A002 chr21 9806202 9846263 A003 chr21 9887188 9988593 A003 chr21 9887188 ...

6. Shell Programming and Scripting

Compare columns in two different files using awk

Hi, I want to compare the columns of two files excluding column 2 from both the files. I tried this awk command. awk -F":" 'NR==FNR{++a;next} !(a)' file1.txt file2.txt . Example: File1.txt 123:09-15-2011:abc:123456 123:09-15-2011:abc:234567 123:09-15-2011:abc:345678 ...

7. Shell Programming and Scripting

Compare columns in different files

Hi, I have two files like this: 8 1.3 10 1.3 12 1.3 15 1.3 21 1.3 and 1 2 3 4 10 11 15 16 21 22

8. Shell Programming and Scripting

[Solved] awk compare two different columns of two files and print all from both file

Hi, I want to compare two columns from file1 with another two column of file2 and print matched and unmatched column like this File1 1 rs1 abc 3 rs4 xyz 1 rs3 stu File2 1 kkk rs1 AA 10 1 aaa rs2 DD 20 1 ccc ...

9. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'...

10. UNIX for Dummies Questions & Answers

Help need to compare columns in files

Hi, Below is my requirement file1 id|cnt 1|1 2|2 3|3 file2 id_1|cnt_1 1|1 2|1 3|1 I want to compare cnt and cnt_1 columns, if they are differ then give the details Am using below awk command, but the output is not as expected.

LEARN ABOUT CENTOS

iso-info

ISO-INFO(1)							   User Commands						       ISO-INFO(1)

NAME

       iso-info - shows Information about an ISO 9660 image

SYNOPSIS

       iso-info [OPTION...]

DESCRIPTION

       -d, --debug=UINT
	      Set debugging to LEVEL

       -i, --input[=FILE]
	      Filename to read ISO-9960 image from

       -f     Generate output similar to 'find . -print'

       -l, --iso9660
	      output similar to 'ls -lR' for an ISO 9660 fs

       -U, --udf
	      output similar to 'ls -lR' for a UDF fs

       --no-header
	      Don't display header and copyright (for regression

       --no-joliet
	      Don't use Joliet-extension information

       --no-rock-ridge
	      Don't use Rock-Ridge-extension information

       --no-xa
	      Don't use XA-extension information

       -r --show-rock-ridge UINT Show if image uses Rock-Ridge extensions
	      A maximum of UINT files will be considered.  Use 0 for all files.

       -q, --quiet
	      Don't produce warning output

       -V, --version
	      display version and copyright information and exit

   Help options:
       -?, --help
	      Show this help message

       --usage
	      Display brief usage message

AUTHOR

       Rocky Bernstein <rocky@gnu.org>

COPYRIGHT

       Copyright (C) 2003-2005, 2007-2008, 2011-2013 R. Bernstein
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.  Have driver: GNU/Linux ioctl and MMC driver Have driver: cdrdao (TOC) disk image driver Have driver: bin/cuesheet disk  image
       driver Have driver: Nero NRG disk image driver Default CD-ROM device: /dev/sr0

SEE ALSO

       cd-info(1) for information about an ISO-9660 image.  cd-read(1) to read portions of an ISO 9660 image.

iso-info							   December 2013						       ISO-INFO(1)