Hi RudiC/Mannu2525 ,
I was also using the sample data which I posted in post#3 .But not sure why in the mismatch details section ,below entries are coming though these entries are not present in sample source/target file.Also I dont need field count in the report.If the below entries can be removed ,then Field lebel Src & Tgt Mismatches should return correct count .
Code:
000101 20
000102 20
000103 20
000104 20
I ran the script like below.
./CompareScrpt1.sh FILE3_S1.txt FILE3_T1.txt
I just the modified file1 and file2 as $1 and $2 in the below mentioned script.
After executing the above script ,analysis report is coming like below :
Code:
<<Analysis Report >>
Src & tgt Count Validation
Source Count : 4
Target Count : 4
Field lebel Src & Tgt Mismatches
No of Mismatches : 8
Mismatch Details:
Mismatch in line Column Name Source Data Target Data
000101 6 123455 123456
000101 20
000102 8 24 23
000102 20
000103 2 000004 3
000103 20
000104 6 3401 3400
000104 20
The above analysis report result is not displaying correct result,the analysis report should come like below :
Code:
<<Analysis Report >>
Src & tgt Count Validation
Source Count : 4
Target Count : 4
Field lebel Src & Tgt Mismatches
No of Mismatches : 4
Mismatch Details:
Mismatch in line Column Name Source Data Target Data
000101 6 123455 123456
000102 8 24 23
000103 2 000004 3
000104 6 3401 3400
If possible ,kindly look into the above mentioned issues.Also as I am new to unix script level ,if you kindly explain the block of code(specially the awk part) ,that will be really beneficial for my understanding.Thanks !
---------- Post updated 07-01-15 at 05:18 AM ---------- Previous update was 06-30-15 at 09:08 AM ----------
Hi RudiC/Mannu2525/All ,
I have tested the below mentinoed script for another sample file ,but analysis report does not provide us correct result.Please find below sample source & target file .
source file :
Are you aware that file1 has 20 fields whereas file2 has 19? Your awk version might dislike that.
This is what I get running the awk script on your sample files
Code:
<<Analysis Report >>
Src & tgt Count Validation
Source Count : 4
Target Count : 4
Field lebel Src & Tgt Mismatches
No of Mismatches : 1
Mismatch Details :
Key Column Value Column Name Source Data Target Data
000001 2 1 100001
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)