Hi All,

I am newbie to Unix I ve got assignment to work in unix

can you please help me in this regard

There is a sample CSV file
"Username", "Password"
"John1", "Scot1"
"John2", "Scot2"
"John3", "Scot3"
"John4", "Scot4"

If i give the column name as Password and row number as 4 the result I should get '

'Scot3'

can you please help me in writing shell script for the above

Thanks
John

What have you tried so far?

I'm assuming this is homework?

First, do you understand how to pass arguments to your script? Do you know what $1, $2 are inside your script?

Next, you need to know how to extract a specific line by number. I realize that the man pages of "sed" are confusing, so to get you going, try

sed -n '4p'

if [ $1 = "Username" ]
then
Column=1
elif  [ $1 = "Password" ]
then
Column=2
fi
echo $Column

read line
Wanted=$1
set $line
if [ $Wanted = $1 ]
then
Column=1
...

Thank Tony ,

I have tried the following code giving error , please do the needful
John.csv is the file name

If i give the column name as Password and row number as 4 the result I should get '

'Scot3'

cat John.csv if [ $1 = "Username" ]
then
  Column=1
elif  [ $1 = "Password" ]
then
  Column=2
fi
echo $Column
read line
Wanted=$1
set $line
if [ $Wanted = $1 ]
then
  Column=1
else 
  echo "Hello"
fi