Shell Programming and Scripting

Hi, try this adaptation:

Code:

awk -v s='^PO_Number=' '
  NR==FNR {
    A[$1]
    next
  }
  {
    for(i=1; i<=NF; i++)
      if (sub(s,x,$i))
        if ($i in A)
          C[$i]++
  } 

  END {
    for(i in A) {
      if (i in C)
        print i " --> " C[i]
      else
        print i > "po_to_server"
    }
  }
' po_numbers Test.log  > list3

Thank You Scrutinizer.
Must appreciated your response.

It worked for me. and the result is really very fast(in seconds.)

I wonder if I could do a uppercase for the input data(po_numbers) for checking in log file as well or the other way around, but i thing tweaking with the search string in the log file for both upper and lower case values will increase the search time.

So,if the input $po itself comes as uppercase then we'll be good in this case.

You're welcome

You could try:

Code:

  NR==FNR {
    A[toupper($1)]
    next
  }

There is also tolower() in awk.

Certainly you can do the counting with the array A (no need for a separate array C).
Of course you need an if (A[i]) condition in the END section.
Is counting required at all?