Sponsored Content
Top Forums Shell Programming and Scripting Need help regarding comparison between two files through UNIX script Post 302948496 by RudiC on Tuesday 30th of June 2015 04:07:20 AM
Old 06-30-2015
Why not cast everything into awk? Try
Code:
awk -F\| '
BEGIN           {print "<<Analysis Report >>\n\nSrc & tgt Count Validation"}

                {for (i=1; i<=NF; i++) TMP[i]=$i
                 if (getline < FN == 1) {SCNT++
                                         for (i=1; i<=NF; i++)
                                                {if (TMP[i] != $i) MMArr[++MMCNT]= $1 "\t" i "\t" TMP[i] "\t" $i}
                                        }
                }
END             {while (getline < FN == 1) SCNT++
                 printf "Source Count : %d\nTarget Count : %d\n\nField lebel Src & Tgt Mismatches\nNo of Mismatches : %d\n\n", SCNT, NR, MMCNT
                 printf "Mismatch Details :\nKey Column Value\tColumn Name\tSource Data\tTarget Data\n"
                 for (i=1; i<=MMCNT; i++) print MMArr[i]
                }
' FN="file1" file2
<<Analysis Report >>

Src & tgt Count Validation
Source Count : 8
Target Count : 4

Field lebel Src & Tgt Mismatches
No of Mismatches : 4

Mismatch Details :
Key Column Value    Column Name    Source Data    Target Data
000101    6    123455     123456
000102    8    24    23
000103    2    000004         3
000104    6    3401       3400

Be aware that I added 4 lines to the source file to verify the algorithm...
This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unix comparison

I am very new to Unix. What are the similiarities and differences between ScoUnix and AIX5 if any? Where might i find the information? Which is better? (1 Reply)
Discussion started by: NewGuy100
1 Replies

2. UNIX for Dummies Questions & Answers

Comparison of 2 files in UNIX

Hi, There are two files in UNIX system with some lines are exactly the same, some lines are not. I want to compare these two files.The 2 files (both the files have data in Column format )should be compared row wise and any difference in data for a particular row should lead to storage of data of... (32 Replies)
Discussion started by: Dana Evans
32 Replies

3. Shell Programming and Scripting

comparison of 2 files

Kindly help on follows. I have 2 files. One file contains only one column of mobile numbers. And total records in a file 12 million. Second file contains 2 columns mobile numbers and balance. and total records 30 million. I want to find out balance of each data in file 1 corresponding to file 2.... (2 Replies)
Discussion started by: kamal_418
2 Replies

4. Shell Programming and Scripting

Comparison of two files (sh)

Hi, I have a problem with comparison of two files file1 20100101 20090101 20080101 20071001 20121229 file2 19990112 12 456 7 20011131 19 20100101 2 567 1 987 17890709 123 555 and, sh script needs to compare of these two files and give out to me result: 20100101 2 567 1 987 it... (5 Replies)
Discussion started by: shizik
5 Replies

5. Shell Programming and Scripting

comparison of 2 files using unix or awk

Hello, I have 2 files and I want them to be compared in a specific fashion file1: A_1200_1250 A_1251_1300 B_1301_1350 B_1351_1400 B_1401_1450 C_1451_1500 and so on... file2: 1210 1305 1260 1295 1400 1500 1450 1495 Now The script should look for "1200" from A_1200_1250 of... (8 Replies)
Discussion started by: Diya123
8 Replies

6. Solaris

Unix script Unix script which counts no. of files/sub-files

Hi All, For past some days iam trying, which not able to get to..so please help me on this.. My exact requirement is... Step1: Find how many files/sub files exist in /some/path (maybe in multiple path) Step2: Count the no. of files/sub files with their respective size. Step3: Then a file... (1 Reply)
Discussion started by: sam09
1 Replies

7. Homework & Coursework Questions

Unix script Unix script which counts no. of files/sub-files

Hi All, For past some days iam trying, which not able to get to..so please help me on this.. My exact requirement is... Step1: Find how many files/sub files exist in /some/path (maybe in multiple path) Step2: Count the no. of files/sub files with their respective size. Step3: Then a file... (0 Replies)
Discussion started by: sam09
0 Replies

8. Shell Programming and Scripting

Comparison between two files through UNIX script

Hi All , As I am new to unix scripting ,I need a help regarding unix scripting .I have two .txt files .One is source file and another is target file.I need a script through which I can compare those two files.I need a automated comparison report in a directory after comparing between source &... (2 Replies)
Discussion started by: STCET22
2 Replies

9. Shell Programming and Scripting

UNIX file comparison

I have two files which has component name and version number separated by a space cat file1 com.acc.invm:FNS_PROD 94.0.5 com.acc.invm:FNS_TEST_DCCC_Mangment 94.1.6 com.acc.invm:FNS_APIPlat_BDMap 100.0.9 com.acc.invm:SendEmail 29.6.113 com.acc.invm:SendSms 12.23.65 cat file2 ... (8 Replies)
Discussion started by: rakeshtomar82
8 Replies

10. Shell Programming and Scripting

Comparison of files

I have the requirement I have two files cat fileA something anythg nothing everythg cat fileB everythg anythg Now i shld use fileB and compare every line at fileA and get the output as something nothing (3 Replies)
Discussion started by: Priya Amaresh
3 Replies
fstrcmp(1)						      General Commands Manual							fstrcmp(1)

NAME
fstrcmp - fuzzy comparison of strings SYNOPSIS
fstrcmp [ -p ] first-string second-string fstrcmp -w first-string second-string fstrcmp -a first-file second-file fstrcmp -s needle haystack... fstrcmp --version DESCRIPTION
The fstrcmp command is used to make fuzzy comparisons between strings. The "edit distance" between the strings is printed, with 0.0 mean- ing the strings are utterly un-alike, and 1.0 meaning the strings are identical. You may need to quote the string to insulate them from the shell. OPTIONS
The fstrcmp command understands the following options: -a --files-as-bytes This option is used to compare two files as arrays of bytes. See fmemcmp(3) for more information. -p --pair This option is used to compare two strings as arrays of bytes. This is the default. See fstrcmp(3) for more information. -s --select This option is used to select the closest needle from the provided haystack alternatives. The most similar (single) choice is printed. If none are particularly similar, nothing is printed. See fstrcmp(3) for more information. See below for example. -V --version This option may be used to print the version of the fstrcmp command, and then exit. -w --wide-pair This option is used to compare two multi-byte character strings. See fstrcoll(3) for more information. EXIT STATUS
The fstrcmp command exits with status 1 on any error. The fstrcmp command only exits with status 0 if there are no errors. EXAMPLE
The fstrcmp --select option may be used in a shell script to improve error messages. case "$action" in start) start ;; stop) stop ;; restart) stop start ;; *) echo "$0: action "$action" unknown" 1>&2 guess=`fstrcmp --select "$action" stop start restart` if [ "$guess" ] then echo "$0: did you mean "$guess" instead?" 1>&2 fi exit 1 ;; esac Thus, the error message frequently suggests the correct action in the face of simple finger problems on the command line. SEE ALSO
fstrcmp(3) fuzzy comparison of strings fstrcoll(3) fuzzy comparison of two multi-byte character strings fstrcmpi(3) fuzzy comparison of strings, integer variation COPYRIGHT
fstrcmp version 0.4 Copyright (C) 2009 Peter Miller Peter Miller <pmiller@opensource.org.au> The comparison code is derived from the fuzzy comparison functions in GNU Gettext 0.17. The GNU Gettext comparison functions were, in turn, derived from GNU Diff 2.7. Copyright (C) 1988-2009 Free Software Foundation fstrcmp(1)
All times are GMT -4. The time now is 02:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy