UNIX for Dummies Questions & Answers

LOC="/sourcefile/"
LOC_FINAL="finalfile/"
Path="base path"
line_num=`wc -l $LOC"abcd.txt"
 
#making directory for temp files
mkdir tempfiles2
chmod 777 tempfiles2

#getting the coloumn names
head -1 $infile > headers3

#removing the newline character and return carriage from headers
#cat $LOC"temp5" | tr -d '\n \r' > $LOC"temp6"
cat headers3 | tr -d '\n \r' > headers1
cat headers1

#now we have the headers so we will create the tem files for all the headers
file_nam1=`cat headers1`
file_nam=`echo "$file_nam1" | tr "\"" " "`
field=1
for i in $file_nam
do
        echo "$i created"
        awk -F"\"" '{print $'$field'}' $LOC"abcd.txt" > $Path"tempfiles2/$i"
        field=`expr $field + 1`
        chmod 777 $Path"tempfiles2/$i"
done
 
#now checking for the missing coloumn names
find_file=`cat abcd_ref`
 
line_no=`echo $line_num |sed 's/ //g'`
echo "line no=$line_no"

for i in $find_file
do
missing_col=`grep $i headers1`
if test "$missing_col" = ""
then
        echo "$i not found"
        #putting tabs in the missing file
        count=0
        while test $count -le $line_no
        do
                echo "  ">$LOC"tempfiles2/$i"
                count=`expr count + 1`
                line_number=`wc -l $LOC"tempfiles2/$i"`
echo "line number of the missing file:$line_number"
        done
fi
done

#now temp files are created, we have to append them in an order

cd $Path"tempfiles2"
paste file1 file2 ........ file 100 > final
 
cp final $LOC_FINAL"abcd.txt"
 
#removing temp files
cd ..
rm -r tempfiles2
rm headers1
exit 0