Shell Programming and Scripting

Hi all

How to verify the number of records in case of delimited file, If the file has records. And then if it is not equal to mentioned no. of records, email is triggered and file is moved to bad directory path.

Example
-----
input file = a.txt
bad directory path : /usr/bin/bad

Hello,

What do you mean my records? Do they mean line numbers?

Thanks,
Shantanu

See In a file contains 50 records

Example a.txt contains

abc|
bcd|
cde|
efg|
ghi|
...
...
upto 50 records...

So to validate how many records in case of delimited file And then if it is not equal to mentioned no. of records, email is triggered and file is moved to bad directory path.

I am still not very clear but I would try to answer whatever little I have understood.

You can use,
$ grep -c ^ a.txt # this will get you the no of lines or records in your file

you can then use this value to check with the mentioned no of records (I don't know from where you get this value) for that file.

See the user has send the file, We have to check that how many records are there in the file in case of delimited. second requ is to check the no of records equal to mentinoed no.of recrds(Initially I know how many records count in a particular file)So i have chk that if its equal or not..if its not equal then email is triggered and file is moved to bad directory path.

Are u looking for something like this?

Code:

[[ `awk 'END{ print NR }' file1` -eq $cnt ]] || { 
mailx "abc@abc.com" -s "Alert..." </dev/null;
mv file1 destination_dir
 }

noOfLines=`wc -l filename`
noOfFields=`cat filename | awk -F"|" '{print NF}'`

#If the file does not have 50 lines or it does not have 10 | delimited fields
# it will be moved to bad dir

if [ noOfLines -ne 50 ] || [ noOfFields -ne 10 ]
then
mailx abc@gmail.com < log
mv filename dest_dir
fi