I have written a code to extract comma seperated values from a file and assign them to a variable inside awk code.i want to use one of these variable to be used in wget function i.e to pass the siteurl.How i can implement the shell command wget inside the awk for loop.code snippet is shown below.
Note:1.sitenames is a csv files name.

awk -F, '{split($0,ar,",");

for(i=0;i<1;i++)
{ siteurl=ar[1];
size=ar[2];
nkeys=ar[3];
print siteurl;
print size;
print nkeys;
# wget www.real.com -o test.txt
for(j=0;j<nkeys;j++)
{
k=4;
keywords=ar[k+j];
print keywords;
}
}
}' sitenames


regards,
Raj

try this

Anbu,
The code which you sent is working but if i pass the siteurl as a variable it do not work.Any ideas how to make it read the value of the siteurl as variable.
I tried this but not working.

system ( "wget $siteurl -o test.txt" )

Regards,
Raj

nawk -v site_url=$siteurl '{system ("wget " site_url " -o test.txt)}'

Hi Marikle,
First of all thank you for your prompt response. Its giving the following error:
testawk.sh: line 19: syntax error near unexpected token `('
testawk.sh: line 19: ` nawk -v site_url=$siteurl '{system ("wget " site_url " -o test.txt)}''




I am attaching the full code :
awk -F, '{split($0,ar,",");

for(i=0;i<1;i++)
{ siteurl=ar[1];
size=ar[2];
nkeys=ar[3];
print siteurl;
print size;
print nkeys;
# echo $nkeys;
nawk -v site_url=$siteurl '{system ("wget " site_url " -o test.txt)}'

# system ( "wget ${siteurl} -o test.txt" )
# wget www.rhapsody.com -o test.txt
for(j=0;j<nkeys;j++)
{
k=4;
keywords=ar[k+j];
print keywords;
}
}
}' sitenames


Let me know where i am doing wrong?/
Regards,
Rajesh

Sorry, forgot to close the quote:

still it shows the same error.I am not able to figure out why?/