unable to run awk command as a shell script

i am tryin开发者_Go百科g to create a shell script to search for a specific index in a multiline csv file. the code i am trying is:

#!/bin/sh

echo "please enter the line no. to search: "
read line

echo "please enter the index to search at: "
read index

awk -F, 'NR=="$line"{print "$index"}' "$1"

the awk command I try to use on the shell works absolutely fine. But when I am trying to create a shell script out of this command, it fails and gives no output. It reads the line no. and index. and then no output at all. is there something I am doing wrong?

I run the file at the shell by typing:

./fetchvalue.sh newfile.csv

Your quoting is not going to work. Try this:

awk -F, 'NR=="'$line'"{print $'$index'}' "$1"

Rather than going through quoting hell, try this:

awk -F, -v line=$line -v myindex=$index 'NR==line {print $myindex}' "$1"

(Index is a reserved word in awk, so I gave it a slightly differet name)