Linux scripting doubts

[maya_pillai]

This is awesome. I never thought this script would look this short and simple.

THANK YOU both blinky and ghostdog74!!

However, I tried to execute this as below. But the variables assigned as $3, $4 ... all are coming as empty. Can you pls suggest?


#!/bin/bash
destDir="../poscntl"
`cd ../posout`
for i in ODS.POS*
do
OIFS="$IFS"
IFS="."
pharmacyid=$3
tablename=$4
timestamp=$5
echo "pharmacyid $pharmacyid"
controlFile="${destDir}/ODS.POS.${pharmacyid}.${timestamp}.ctl"
IFS="$OIFS"
for datafile in ODS.POS.${pharmacyid}*
do
rcount=$(wc -l "${datafile}")
md5sum=$1
echo " The file name is : ${datafile}" >> ${controlFile}
echo " The row count is : ${rcount}" >> ${controlFile}
echo " The table name is : ${tableName} " >> ${controlFile}
echo " The time stamp is : ${timestamp} " >> ${controlFile}
echo " The md5sum is : ${md5sum}" >> ${controlFile}
echo " -----------------------------------------------------------------" >> ${controlFile}
done
done


Thanks
Maya

[blinky]

I don't think this is what you want, it will process files (for each pharmacyid) multiple times. if you have 2 files for a pharmacyid, it will produce 4 entries in the ctl file.

#!/bin/bash
destDir="../poscntl"
cd ../posout

for i in ODS.POS*
   do
      OIFS="$IFS"
      IFS="."
      set -- ${i}
      pharmacyid=$3
      tablename=$4
      timestamp=$5
      echo "pharmacyid $pharmacyid"
      controlFile="${destDir}/ODS.POS.${pharmacyid}.${timestamp}.ctl"
      IFS="$OIFS"
      for datafile in ODS.POS.${pharmacyid}*
      do
         rcount=$(wc -l "${datafile}")
         md5sum=$1
         echo " The file name is : ${datafile}" >> ${controlFile}
         echo " The row count is : ${rcount}" >> ${controlFile}
         echo " The table name is : ${tableName} " >> ${controlFile}
         echo " The time stamp is : ${timestamp} " >> ${controlFile}
         echo " The md5sum is : ${md5sum}" >> ${controlFile}
      echo " -----------------------------------------------------------------" >> ${controlFile}
   done
done

======================
This one process files (for each pharmacyid) once. if you have 2 files for a pharmacyid, it will produce 2 entries in the ctl file.

for pharmacyid in `ls ODS.POS.* | cut -d "." -f 3 | sort -u` gives you the unique pharmacyid, you then process all the files for that pharmacyid

#!/bin/bash
destDir="../poscntl"
cd ../posout

for pharmacyid in `ls ODS.POS.* | cut -d "." -f 3 | sort -u`
do
   echo "pharmacyid $pharmacyid"
   controlFile="${destDir}/${pharmacyid}.ctl"
   echo  > ${controlFile}
   for datafile in ODS.POS.${pharmacyid}.*
   do
    
      OIFS="$IFS"
      IFS="."
         set -- ${datafile}
         tableName="${4}"
         timestamp="${5}"
      IFS="$OIFS"

      set -- $(wc -l "${datafile}")
      rcount="$1"
      set -- $(md5sum "${datafile}")
      md5sum="$1"
      echo " The file name is : ${datafile}" >> ${controlFile}
      echo " The row count is : ${rcount}" >> ${controlFile}
      echo " The table name is : ${tableName} " >> ${controlFile}
      echo " The time stamp is : ${timestamp} " >> ${controlFile}
      echo " The md5sum is : ${md5sum}" >> ${controlFile}
      echo " -----------------------------------------------------------------" >> ${controlFile}
    
   done
done

[maya_pillai]

Thanks you SO MUCH! its Perfect!

Maya