Syntax reminder: Get number of DML operations from GoldenGate replicat report file

This little piece of a bash code lets you obtain number of DML operations from Oracle GoldenGate report file:

#!/bin/sh
dml_cnt=`perl -p -e 's/\s{2,}/\t/g' /opt/oracle/ggate/dirrpt/R1.rpt | awk -F "\t" '($3 ~/(inserts|updates|deletes):/){dml_count += $4} END {print dml_count}'`

Useful script for greping all files excluding those that match specific pattern

grep -Pn 'Win_' `ls -1 *.ahk | grep -vPi 'Win|recall.*ahk' | awk '{printf $1 " "}'`