Shell Programming and Scripting

a,b,c,d,e,g h http://mysite.xyx
z,b,d,f,e,s t http://123124#
a,b,c,i,m,nothing
d,i,j,e,w,nothing

a,b,c,d,e,http://mysite.xyx
z,b,d,f,e,http://123124#
a,b,c,i,m,nothing
d,i,j,e,w,nothing

for i in `cat file.csv`
do
first=$i|awk '{print $1}'
second=$i|awk '{print $2}'
third=$i|awk '{print $3}'
four=$i|awk '{print $4}'
five=$i|awk '{print $5}'
six=$i|awk '{print $6}'
 if [ $six = "nothing" ] 
 then
 six=$six
 else
    six=`grep -o 'http.*' $six`
 fi
echo "$first,$second,$third,$four,$five,$six"
 done >> output.csv

awk -F',| ' '{print $1,$2,$3,$4,$5,$NF}' OFS=,   Input_file

awk 'NF>1{sub(/[^,]*$/,$NF)}1' file

sed 's/[^,]* //' file

awk '{sub(/[^,]* /,x)}1' file