UNIX for Beginners Questions & Answers

awk'...' Ariba.csv FS=, Pay.csv > outputfile.csv

if (SUM) print "Variance is not zero: ", SUM/100

#!/bin/bash/sh
a=0.000000
for value in `cat file1  | grep Total | tr -s " " " " | cut -d " " -f2`
do
a=$(echo $a + $value | bc)
done
echo "file1 : $a"
b=0.000000
for value2 in `cat file2 | cut -d "," -f7 | sed -e 's/^"//g' -e 's/"$//g'`
do
b=$(echo $b + $value2 | bc)
done
echo "file2 Total: $b"
if [ $a = $b ]
then
echo "Total is same"
fi

awk '
FNR == 1        {next
                }
FNR == NR       {if (/^Total/) SUM1 += $2*100
                 next
                }
                {SUM2 += $7*100
                }
END             {print SUM1/100, SUM2/100, "Variance: ", (SUM2 - SUM1))/100
                }
' Ariba.csv Pay.csv

PaymentId,InvoiceReconciliationId,PurchasingUnit,InvoiceNumber,InvoiceDate,Supplier,GrossAmount,GrossAmountCurrency,PaymentTerms,ForTaxAccrual,SupplierLocation,SupplierLocationContactID,RemittanceLocation,cus_ManualInvoiceNumber,cus_LocationCode_UniqueName,cus_EstimatePaymentDate,cus_CreateDate,cus_SupplierName,cus_PaymentDescription,cus_RequesterPIN
"PAYMXF5477-209123","IRMXF5477-209123",,"MXF5477","06/04/2018 05:09:00 -0700","5002362","110.6500","USD","Net 30","No","5002362","5002362","RL_INTERNAL50834041",,,,"Mon Jun 4 10:10:13 PDT 2018","CDW DIRECT LLC",,"1541"
"PAY81171-209097","IR81171-209097",,"81171","05/31/2018 09:23:00 -0700","VM1039342","5775.0000","USD","Net 00","No","VM1039342","VM1039342",,,,,"Mon Jun 4 09:24:22 PDT 2018","PAYSCALE INC",,"3661"
"PAYMXF5657-209126","IRMXF5657-209126",,"MXF5657","06/04/2018 05:11:00 -0700","5002362","24.9800","USD","Net 30","No","5002362","5002362","RL_INTERNAL50834092",,,,"Mon Jun 4 10:12:06 PDT 2018","CDW DIRECT LLC",,"7337"

if [ $string == 'GrossAmount' ]; then

echo "$string"

sed -i '1d' $filename

fi