Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Comparing two files and writing mismatched rows along with mismatched columns. Pointing out the mism
Top Forums UNIX for Advanced & Expert Users Comparing two files and writing mismatched rows along with mismatched columns. Pointing out the mism Post 302997144 by drl on Monday 8th of May 2017 01:29:03 PM
Old 05-08-2017
HI.

Using your sample data, here is a solution using a GNU utility, dwdiff. Basically, it operates on space-separated words, so I modified your sample files to be that instead of | separated:
Code:
#!/usr/bin/env bash

# @(#) s1       Demonstrate field/word diff, dwdiff.

# Utility functions: print-as-echo, print-line-with-visual-space, debug.
# export PATH="/usr/local/bin:/usr/bin:/bin"
LC_ALL=C ; LANG=C ; export LC_ALL LANG
pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
em() { pe "$*" >&2 ; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && $C dwdiff

FILE=${1-data1}

pl " Input data files:"
head data?

pl " Amended data files::"
sed 's/|/ /g' data1 > t1
sed 's/|/ /g' data2 > t2
head t?

pl " Results:"
dwdiff t1 t2

pl " More details for dwdiff:"
dixf dwdiff

exit 0

producing:
Code:
$ ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 3.16.0-4-amd64, x86_64
Distribution        : Debian 8.7 (jessie) 
bash GNU bash 4.3.30
dwdiff 2.0.9

-----
 Input data files:
==> data1 <==
1|piyush|bangalore|dev 
1|piyush|bangalore|QA 
2|pankaj|bangalore|dev 
3|rohit|delhi|QA

==> data2 <==
1|piyush|bangalore|QA 
1|piyush|bangalore|QA 
2|pankaj|bangalore|dev 
3|rohit|bangalore|dev

-----
 Amended data files::
==> t1 <==
1 piyush bangalore dev 
1 piyush bangalore QA 
2 pankaj bangalore dev 
3 rohit delhi QA

==> t2 <==
1 piyush bangalore QA 
1 piyush bangalore QA 
2 pankaj bangalore dev 
3 rohit bangalore dev

-----
 Results:
1 piyush bangalore [-dev-] {+QA+} 
1 piyush bangalore QA 
2 pankaj bangalore dev 
3 rohit [-delhi QA-] {+bangalore dev+}

-----
 More details for dwdiff:
dwdiff  a delimited word diff program (man)
Path    : /usr/bin/dwdiff
Version : 2.0.9
Type    : ELF 64-bit LSB executable, x86-64, version 1 (SYSV ...)
Help    : probably available with --help
Repo    : Debian 8.7 (jessie)

Note that the braces enclose the markers + for an addition, - for a deletion.

There are a number of additional options. See man dwdiff for details.

Best wishes ... cheers, drl
 

10 More Discussions You Might Find Interesting

1. HP-UX

ld: Can't find library or mismatched ABI for -lstdc++

Hi, I am having problem of linking .o and I am working with HP -UX gcc version is 3.4.2 . I have complied few cpp files and got .o's. But at the time of linking i am having issue. it is returning ld: Can't find library or mismatched ABI for -lstdc++ Fatal error. I have lib at location ... (0 Replies)
Discussion started by: ghananil
0 Replies

2. HP-UX

ld: Can't find library or mismatched ABI for

I started building a program which connects to MySQL and got: ld: Can't find library or mismatched ABI for -lmysqlclient_r I tried building my own MySQL and use these, and it worked but then it gave me: ld: Can't find library or mismatched ABI for -lrt But librt is a system library (and... (1 Reply)
Discussion started by: selalerer
1 Replies

3. HP-UX

ld: Can't find library or mismatched ABI for -lstlport_aCC

Hi All, while compiling on HP UX, i am getting the following error ld: Can't find library or mismatched ABI for -lstlport_aCC i am new to unix and HPUX, please suggest solution ASAS thanks in advance vindhyalesh (3 Replies)
Discussion started by: vindhyalesh
3 Replies

4. Linux

Error Mismatched object file

Dear All, Need your help to rectify this error. Recently I have upgraded my Linux server from 32 bit to 64 bit server. OS details are Red Hat Enterprise Linux Server release 5.3 Kernel 2.6.18-120.el5 on an x86_64 After upgradation, when i try to compile or catalog any program, it is... (2 Replies)
Discussion started by: mysmileforu
2 Replies

5. Shell Programming and Scripting

Comparing rows in same file and writing the result in new file

Help needed... Can you tell me how to compare the last two couple entries in a file and print their result in new file..:confused: I have one file Check1.txt \abc1 12345 \abc2 12327 \abc1 12345 \abc2 12330 I want to compare the entries in Check1 and write to... (1 Reply)
Discussion started by: kichu
1 Replies

6. Shell Programming and Scripting

Comparing rows and columns

Hi, i've a .csv file with the data as below: - file1.h, 2.0 file2.c, 3.1 file1.h, 2.5 file3.c, 3.3.3 file1.h, 1.2.3 I want to remove the duplicate file names considering only the one with the highest version number.. output should be file1.h, 2.5 file2.c, 3.1 file3.c,... (3 Replies)
Discussion started by: pravsripad
3 Replies

7. Shell Programming and Scripting

Comparing Columns and writing a new file

I have a table with one column File1.txt 1 2 3 4 5 6 7 8 9 10 Another table with two columns; This has got a subset of entries from File 1 but not unique because they have differing values in col 2. File2.txt 1 a 2 d 2 f 6 r 6 e (3 Replies)
Discussion started by: cs_novice
3 Replies

8. UNIX for Dummies Questions & Answers

Writing a script to take the average of two columns every 3 rows

I have a dataset with 120 columns. I would like to write a script, that takes the average of every two columns, starting from columns 2 and 3, and moving consecutively in frames of 3 columns, all the way until the last column. The first column in the output file would be the averages of columns... (1 Reply)
Discussion started by: evelibertine
1 Replies

9. Shell Programming and Scripting

awk delimiter count if mismatched?

Hi all, I have a file where in it has lot of records in it. I have written below stuff to find the number of fields as shown below `awk -F '|' '{print NF-1}' file.txt| head -1` how do i proceed if in case any record in particular is having more number of delimiters, if it having??? what... (7 Replies)
Discussion started by: nikhil jain
7 Replies

10. Programming

Mismatched free() / delete / delete [] line no missing

Could you tell me the possibilities of the reason to get the Mismatched free() / delete / delete . I unable to see the line no in the valgrind report. it displays the function name. with that function name, I am not able to find where exactly the issue is there.I am getting the Mismatched free()... (3 Replies)
Discussion started by: SA_Palani
3 Replies

LEARN ABOUT OPENSOLARIS

tee

tee(1)								   User Commands							    tee(1)

NAME

       tee - replicate the standard output

SYNOPSIS

   /usr/bin/tee
       /usr/bin/tee [-ai] [file]...

   ksh93
       tee [-ail] [file]...

DESCRIPTION

   /usr/bin/tee
       /usr/bin/tee  copies  standard  input  to standard output, making a copy in zero or more files. tee does not buffer its output. The options
       determine if the specified files are overwritten or appended to.

   ksh93
       The tee built-in in ksh93 is associated with the /bin and /usr/bin paths. It is invoked when tee is executed without a pathname prefix  and
       the pathname search finds a /bin/tee or /usr/bin/tee executable.

       tee  copies  standard input to standard output and to zero or more files. The options determine whether the specified files are overwritten
       or appended to. The tee utility does not buffer output. If a write to a file fails, tee continues to write to other files although it exits
       with a non-zero exit status.

       The number of file operands that can be specified is limited by the underlying operating system.

OPTIONS

   /usr/bin/tee
       The following options are supported by /usr/bin/tee:

       -a    Appends the output to the files rather than overwriting them.

       -i    Ignores interrupts.

   ksh93
       The following options are supported by the tee built-in command in ksh93:

       -a		      Appends the output to the files rather than overwriting them.
       --append

       -i		      Ignores SIGINT signal.
       --ignore-interrupts

       -l		      Sets the standard output to be line buffered.
       --line-buffer

OPERANDS

       The following operands are supported:

       file    A path name of an output file. Processing of at least 13 file operands are supported.

USAGE

       See largefile(5) for the description of the behavior of tee when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of tee: LANG, LC_ALL, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

EXIT STATUS

   /usr/bin/tee
       The following exit values are returned by /usr/bin/tee:

       0     The standard input was successfully copied to all output files.

       >0    The number of files that could not be opened or whose status could not be obtained.

   ksh93
       The following exit values are returned by tee in ksh93:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

   /usr/bin/tee
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |Standard		     |See standards(5). 	   |
       +-----------------------------+-----------------------------+

   ksh93
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |See below.		   |
       +-----------------------------+-----------------------------+

       The ksh93 built-in binding to /bin and /usr/bin is Volatile. The built-in interfaces are Uncommitted.

SEE ALSO

       cat(1), ksh93(1), attributes(5), environ(5), largefile(5), standards(5)

SunOS 5.11							    20 Nov 2007 							    tee(1)
All times are GMT -4. The time now is 02:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy