UNIX for Dummies Questions & Answers

Hi MadeInGerrmany,

I am not sure, My point is if we can match the sum with that of trailer record manually when opened through excel, why cant unix do that validation.

How can we make the code generic. The very purpose of writing this shell script is to automate what we do manually daily by opening the file in excel and check the sum of all rows under each column matches with its corresponding trailer record under the same column.

Having said that I am automating the manual process, by enforcing this validation on already successfully loaded production files I cant go back to source and tell source that your file has wrong data.

The files I have attached are production files and they have successfully passed the validations and data is loaded into production.

Please help me out!!!!

With Regards,
TPK

---------- Post updated at 10:26 PM ---------- Previous update was at 10:55 AM ----------

Hi All/Experts,

Is there a solution to my problem mentioned in post 8 of this thread? Is it possible to go with shell scripting?

Why Excel calculation and unix awk sum calculation are not being same?

When I open in Microsoft Excel the same csv file and do a sum it's matching with the trailer record, The same thing when I do in Unix with awk it's getting failed when I am trying to compare the sum with that of trailer record.

Please help me out, Many Thanks in advance!!!!!

With Regards,
TPK

You've been given a complete solution in post#2, replacing almost your entire script in post#1, except for the output and exit code which you could easily adapt. It compares values and not strings (as MadeInGermany also pointed out), so some decimal places ".00" don't matter.

I suspect Excel has produced the input file with a not exact (i.e. false) value in the last column.
If your team insists this is okay, then you need the same (faulty) Excel to get a positive verification.
The sums produced by awk are correct. You cannot expect that awk copies a faulty behavior.