Shell Programming and Scripting

awk '
{
for(i=1; i<=NF; i++)
  if($i ~ /ABCD./)
  printf($i); printf("\n")
}
' pbdw.d.txt > out.log


awk: Input line SELECT ACCT_NUM , ST cannot be longer than 3,000 bytes.
 The input line number is 204. The file is pbdw.d.txt.
 The source line number is 5.

awk -v RS=" " '
    {
        n=split( $0, a, "\n" );
        for( i = 1; i <= n; i++ )
            if( (m = split( a[i], b, "." )) == 2 && b[1] == "ABCD" )
                count[b[2]]++;     # count each occurrence of table name
    }
    END {
        for( c in count )   #print each table and count
            printf( "%5d %s\n", count[c], c );
    } ' input-file-name |sort  -k 1nr,1

awk -v RS=" " '
    {
        n=split( $0, a, "\n" );
        for( i = 1; i <= n; i++ )
            if( (m = split( a[i], b, "." )) == 2 && b[1] == "PBDW" )
                count[b[2]]++;     # count each occurrence of table name
    }
    END {
        for( c in count )   #print each table and count
            printf( "%5d %s\n", count[c], c );
    } ' ABCD.D_P1.f.txt |sort  -k 1nr,1  > ABCD.D_P1.f.count.txt