#!/bin/tcsh
foreach year ( ???? )
	foreach exp ($year/*-*)
		set report_num=`basename $exp`
		echo update assembled set report_link=\'http://ds.iris.edu/data/reports/$year/$report_num\' where report_num=\'$report_num\'';'
	end
end 	 

