comparing csv files

Shell Programming and Scripting
1

Hi!
I'm just new to shell scripting n simple tasks looks so tough in initial stage. i need to write a script which will read a property file, property file will be containing count of the csv files, and in a folder(same folder) there will be respective csv files.
like Property file
data1=100
data2=50
data3=45
data4=40
and in a directory corresponding csv files will be there.

I need to make a script that can first read property file and search for the keyword like data1 csv files in folder and match the count, if they are equal proceed proceed further if not send an error mail. i totally confused with this, its like climbing mountain like a newbie for me....plz help me out with this:(
Thanks a lot..

2

To climb mountains, you need good shoes for a start...Are you equiped? :rolleyes:

I always use to make mountains out of things till I went I see a psychiatrist...
First thing to learn is to analyse correctly the task ( describe!!) then strip down to the maximum all that is involved (to elementary tasks...) leaving aside what you don't know yet and try to express the result into pseudocode, if that is done then it is just a question of translating...
We will be glad to help you once we have seen a start (even pseudocode...)

Courage!

3

Hi vbe thanks for advising me the right way to learn...
as per my little knowledge i tried to make pseudo code...

1.Find *data1* in prop file
2. Count value against *data1*
3. Store in var1
4. Search and count *data1*.csv
5. Store the count in var2
6. if var1=var2
return 0
7. else
trigger mail
8.done

hope i m on right way ....guide me further @vbe also tell me some good links n books to learn shell scripting....
thanks

4

Hi as per my experience in scripting.. i tried i'm posting here... i know its need a lot of corrections as well as making all the commands together...

   #!/bin/bash
  #while loop to read line by line
  N=0
  While read LINE ; do
  N=$((N+1))
  echo �Line $N = $LINE
  done
  
   
    # cut command to extract columns
  cut -f 1,3,4 -d �|' Jewson.csv
  
   
    #if else clause to check the columns if they contain something or empty
  if ($1==[a-zA-Z][0-9] && $2==[a-zA-Z][0-9] && $3==$1==[a-zA-Z][0-9])
  then
  return 0
  else
  #send mail to admin {code for sendmail server}
  fi

Now anyone can please help me out to make a working script for my need.
thanks...