Get the value from a .csv files 1

[ajayarora]

Hi,

My requirement is to get the arguments for a stored proc from a .csv file. Only problem in getting the arguments is the spaces in between the values.e.g.the file is like
123,first name,last name,1000
arg1=123
arg2=first name
arg3=last name
arg4=1000.

Any help on this would be appreciated.

Thanks
Ajay.

 

[PHV]

Try this:

(IFS=","; while read arg1 arg2 arg3 arg4; do
 echo "1='$arg1' 2='$arg2' 3='$arg3' 4='$arg4'"
done)</Path/to/file.csv

Hope This Help
PH.

 

[ajayarora]

Many Thanks.
What if I just want to extract the first three parameters?
Actually in that case your script displays 3=last name,1000.

Regards
Ajay.

 

[PHV]

You have to read at least 4 parameters. Simply ignore the value of $arg4 inside the read loop.

Hope This Help
PH.

 

[ajayarora]

Many Thanks for you help.