reading a column value from a text file

gomes009 · #1 (**permalink**) 02-10-04, 21:05

I am trying to compare two values from different sources and store the result into a shell variable. FileA has 4500 records in this example. I want to count the number of records in FileA and compare that with totalcount_fileA column in FileB

FileB file format is as follows: The file will not contain the column names.

SourceName source_date totalcount_fileA filedate,
Hello 12/04/2003 4500 2/04/2003

Any help is appreciated

aigles · #2 (**permalink**) 02-11-04, 02:09

Try and adapt the following code :

Code:

CountA=`wc -l FileA | awk '{ print $1}'`
CountB=`awk 'NR==2 {print $3;next}' FileB`
if [ $CountA -eq $CountB ]
   then echo "Ok"
   else echo "Counts does'nt match"
fi

Damian Ibbotson · #3 (**permalink**) 02-11-04, 05:20

Quote:

FileB file format is as follows: The file will not contain the column names.

SourceName source_date totalcount_fileA filedate,
Hello 12/04/2003 4500 2/04/2003

Are you saying that there may be many FileA, and FileB contains the expected record count for each FileA value?

If so, this might help you...

Code:

awk '
{
 fname=$1; fcount=$3
 "wc -l "fname | getline # this pipes the system call to 'wc'
                         # the stdout is read in to replace $0
 print fname " - Expected count: "fcount"; Actual Count: "$1
}' FileB

Damian

aigles · #4 (**permalink**) 02-11-04, 06:06

Sorry, FileB not contain the column names.

Code:

CountA=`wc -l FileA | awk '{ print $1}'`
CountB=`awk '{print $3;exit}' FileB`
if [ $CountA -eq $CountB ]
   then echo "Ok"
   else echo "Counts does'nt match"
fi

gomes009 · #5 (**permalink**) 02-11-04, 21:12

Thanks, it worked. I appreciate.

Internet Services

Web Development

Digital Marketing

Consumer Tech