Awk compare two files Post: 302667143

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Operating Systems HP-UX Awk compare two files Post 302667143 by Corona688 on Thursday 5th of July 2012 04:31:26 PM

Old

07-05-2012

Registered User

Code:

$ cat xcomm.awk

BEGIN { FS="|"; OFS="|" }

F != FILENAME { FNUM++; F=FILENAME }

$1 SUBSEP $2 in COL {
        if(FCOL[$1, $2, COL[$1,$2]] != $0)
        {
                print FCOL[$1,$2, COL[$1,$2]] >"diff";
                print > "diff";
        }
}

{       COL[$1,$2]=FNUM; FCOL[$1, $2, FNUM]=$0  }

END {
        for(X in COL)   for(N=1; N<=FNUM; N++)
        {
                if(! (X SUBSEP N in FCOL))
                        print FCOL[X SUBSEP COL[X]] >"missing-"N
        }
}

$ awk -f xcomm.awk data1 data2

$ cat diff

ABC|2289|611.09
ABC|2289|666.08
ABC|2290|698
ABC|2290|698.00
DEF|1513|721.3
DEF|1513|721.30
DEF|1514|40
DEF|1514|40.00
DEF|1515|5
DEF|1515|5.00

$ cat missing-2

ABC|2203|115.50

$

This User Gave Thanks to Corona688 For This Post:

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk compare 2 files

Hi i hope some awk gurus here can help me.. here is what i need i have 2 files: File1 152445 516532 405088.pdf 152445 516533 405089.pdf 152491 516668 405153.jpg 152491 520977 408779.jpg 152491 0 409265.pdf File2 516532 /tmp/MainStreet_Sum09_Front_FNL.pdf 516533...

2. Shell Programming and Scripting

Compare two files using awk

Hi. I'm new to awk and have searched for a solution to my problem, but haven't found the right answer yet. I have two files that look like this: file1 Delete,3105551234 Delete,3105551236 Delete,5625559876 Delete,5625556789 Delete,5625553456 Delete,5625551234 Delete,5625556956...

3. Shell Programming and Scripting

compare two files using awk

Hi, I want to compare two files using awk and write an output based on if the records matched. Both the files are space delimitted. File A: 8351 00000000000636 2009044 -00001.000 8351 00000000000637 2009044 -00002.000 8351 00000000000638 2009044 -00001.000 8351 00000000000640...

4. UNIX for Dummies Questions & Answers

Using AWK to compare 2 files

Hi How can I use awk to compare specific columns in 2 files and print the difference. I currently have this: BEGIN { OFS = FS = "," } NR == FNR { b = $3 next } { e = "" for (x in b) { if (match ($1, x)) { if (RSTART == 1 && RLENGTH > length(e)) { e=x

5. Shell Programming and Scripting

Compare two files with awk

Hello, I have a script which extracts the values from a csv file when a specific date is entered : #!/bin/sh awk 'BEGIN{printf("Entrez la date : "); getline date < "-"} $0 ~ date {f=1;print;next} /^{2}\//{f=0} f' file1.csv This script gives me a number of lines with different values. ...

6. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the...

7. Shell Programming and Scripting

Compare files using awk

Please help me to compare two files and remove the items in file2 from file1 file 1:delimited using pipe(|) file1 00012|Description - 1|||||AA12345|1|AB12345|2|2012/06/03 AB123|Description - 2|||||AA12345|3|ZA11111|4|2012/06/04 11111|Description - 3|||||AP00012|1|AB12345|2|2012/06/03...

8. Shell Programming and Scripting

Compare 2 files, awk maybe?

I have 2 files, file1: alfa numbers numbers vita numbers numbers gama numbers numbers delta numbers numbers epsilon numbers numbers zita numbers numbers ... file2: 'zita' keepnumbers keepnumbers keepnumbers 'gama' keepnumbers keepnumbers keepnumbers 'misc' ...

9. Shell Programming and Scripting

awk compare files

I have a below requirement and trying to compare the files using awk File 1 - Already stored on a prev day id | text | email id --------------------------------- 89564|this is line 1 | xyz@sample.txt 985384|this is line 2 | abc@sample.txt 657342|this is line 3 |...

10. Shell Programming and Scripting

[awk] Compare two files

HI!! I am trying to compare two files using AWK but I have some problems. I need to count how many times letters are used in two texts. This is my script { long=length($0) for (i=1;i<=long;i++) { aux=substr($0,i,1) if ( aux != " " && aux != "" ) ...

LEARN ABOUT V7

col

COL(1)							      General Commands Manual							    COL(1)

NAME

       col - filter reverse line feeds

SYNOPSIS

       col [-bfx]

DESCRIPTION

       Col  reads the standard input and writes the standard output.  It performs the line overlays implied by reverse line feeds (ESC-7 in ASCII)
       and by forward and reverse half line feeds (ESC-9 and ESC-8).  Col is particularly useful for filtering multicolumn output  made  with  the
       `.rt' command of nroff and output resulting from use of the tbl(1) preprocessor.

       Although  col  accepts  half  line motions in its input, it normally does not emit them on output.  Instead, text that would appear between
       lines is moved to the next lower full line boundary.  This treatment can be suppressed by the -f (fine) option; in  this  case  the  output
       from col may contain forward half line feeds (ESC-9), but will still never contain either kind of reverse line motion.

       If  the	-b  option is given, col assumes that the output device in use is not capable of backspacing.  In this case, if several characters
       are to appear in the same place, only the last one read will be taken.

       The control characters SO (ASCII code 017), and SI (016) are assumed to start and end text in an alternate character  set.   The  character
       set  (primary or alternate) associated with each printing character read is remembered; on output, SO and SI characters are generated where
       necessary to maintain the correct treatment of each character.

       Col normally converts white space to tabs to shorten printing time.  If the -x option is given, this conversion is suppressed.

       All control characters are removed from the input except space, backspace, tab, return, newline, ESC (033) followed by one of 789, SI,  SO,
       and  VT (013).  This last character is an alternate form of full reverse line feed, for compatibility with some other hardware conventions.
       All other non-printing characters are ignored.

SEE ALSO

       troff(1), tbl(1), greek(1)

BUGS

       Can't back up more than 128 lines.
       No more than 800 characters, including backspaces, on a line.

																	    COL(1)