extract coordinates and location name from a TXT file.

Hi all,

I m finishing my thesis and this is the last step to be done.

I have an xls file with 4 columns (Location, lat, lon and wheat_yield) and a netcdf file containing annual Surface Solar Radiation data.

I need to extract all the 200 locations and the annual solar rad corresponding to this location.

Any idea?

LEts start from how can I extract Srad from each location and name the output file as : location.nc

the following example works only for one location manually : cdo -remapbil,lon=-0.44lat=53.874 CLIMATOLOGY20032007.nc Leconfield.nc

cheers.

CDO