Shell Programming and Scripting

Hi
Am having 2 files.

I have one data file.
before inserting in to the table am taking cout of the data file and store as data 1.

After insert in to the table and am taking the count from the table and store as data2.

If i try to compare those values

Code:

If [ $data1 = $data2]
then 
  echo "data match"
else
  echo "data mismatch"

The issue is am having the same value in data 1 and data 2,but still am getting data mismatch error.

Is anything wrong in my code?

Please advice.

thats because the value of count that you are fetching from database may have some space.. can you post that query and settings(like set head off,set feedback off,set pages 0 etc)

Code:

if [ "$data1" = "$data2" ]

i did the adviced changes ,still am getting the difference...Since the values on the data file are same.

---------- Post updated at 02:16 AM ---------- Previous update was at 02:16 AM ----------

Please any other idea..to over come this?

before comparing data1 and data2 do this

Code:

echo "$data1"|cat -vet
echo "$data2"|cat -vet

and post the o/p

Below is a better way to compare two numbers

If [ "$data1" -eq "$data2" ]

Regards,

Ranjith