Is this possible using SED and AWK?

Shell Programming and Scripting
1

Dear Geeks,

I want to manipulate a file with certain modifications for that using sed or AWK how to do this process for one file i have this type of data.

Input File:

"Restricted and Reserved names .ANISH",3798,"TEST.CO",1201208,6/16/10   0:00,6/16/13   0:00,,,"CO","2nd"^M
"Restricted and Reserved names .ANU",3798,"TESTTEST.CO",1201208,6/16/10   0:00,6/16/13   0:00,,,"CO","2nd"^M

I want output to other file like this :

3798,http://TEST.CO/
3798,http://TESTTEST.CO/
2

Try this,

nawk -F"," 'gsub(/"|"/,"",$0){print $2 ",http://"$3"/"}' txt

Regards,
Indu

3 
sed -n 's|^[^,]*,\([^,]*\),"\([^,]*\)",.*$|\1,http://\2/|p' <filename>
4 
sed 's/"//g' | awk -F "," '{ print $2",http://"$3"/" }'
5 
awk -F, '{$0=$2 ",http:/" $3} gsub(/"/,"/")' file