Shell Programming and Scripting

Hi Jim,

The following script is in working state. But i m having one more problem with awk cmd. Could you tell me how to use any variable inside awk or how to take any variable value outside awk.
My problem is i want to maintain one property file in which i am declaring variable value into that property file and want to use that variable into awk script.
example.
file name:validate.property
INT_EUR=14
INT_TOK=54

now these two variable i want to use it into my shell script. new.sh which i wrote below.
Also one more thing .How to find scane arount 50000 records with minimum time. Actually the following script scan 42000 records in 6 min, i need to scan in 1 min is there any method in shell script.
i Hope u understand my problem. Could you please help me out.

Waiting for you reply.

Code:

#!/bin/bash
DATA_DIR=/export/opt/rtrupld/autosys/scripts_old
data=`ls $DATA_DIR/count.txt`


  awk ' END {print NR}' $data
  awk ' {          sum=0;

       print "Total lines",NR

      for(i=1; i<= length($0); i++) {if (substr($0,i,1)=="~" ) {sum++}  }
        if (NR !=1)
      {
       print "Total lines:::",NR
         print "oldsum :::",oldsum
         print "sum :::",sum
        if (oldsum==sum){
        print "oldsum",oldsum
      }
        else
        {
           if(oldsum!=sum)
              {print "error in ", $data," at line   ",NR,  " tilde
count=",sum}
            exit;
        } } else{
      oldsum=sum
      print "oldsum at last",oldsum
      }

      }'  $data