The file dbnames.txt has 5 columns, what i'm trying to do is that when the fifth column equals A, store in the variable "access" the word, "admin access". If it equals B, then "business access" etc. I think their is a problem with my sed command, because it is not substibstituting the words correctly. Any ideas?

thanks,

ross_one

tput cup 13 0; echo "Enter your name:"
tput cup 13 16; read name
location=`find dbnames.txt`
x=`grep -c "$name" "$location"`
if [ $x -gt 0 ]
then
tput cup 15 0; echo "Name found!"
grep "$name" "$location" | cut -f 1,2,3,4,5 -d, | tr ',' ':' > temp.txt
y=`grep -F "$name" "temp.txt" | cut -f5 -d:`
case "$y" in

"A")
access="Administrator access" ;;
"B")
access="Business access" ;
"C")
access="Secretary access" ;;
*)
access="General access" ;;
esac

sed -e "s/A/$access/i" -e "s/B/$access/i" -e "s/S/$access/i" -e "s/G/$access/i" < temp.txt > test2.txt

cat test2.txt

fi