UNIX for Dummies Questions & Answers

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

Are you sure $access is being set to the correct value? Try echoing it just before your sed script. Add other echos as required to help you debug, e.g. to make sure $y is being set correctly, etc.

You are missing one semi-colon in your case statement.

Also consider that using s///i means case is ignored, so it might change A into "Administrator access", and then the s/S/$access/i would change it into AdminiAdministrator accesstrator access.