Index: trunk/MagicSoft/Mars/datacenter/scripts/zipscript
===================================================================
--- trunk/MagicSoft/Mars/datacenter/scripts/zipscript	(revision 9047)
+++ trunk/MagicSoft/Mars/datacenter/scripts/zipscript	(revision 9049)
@@ -56,5 +56,5 @@
 do
    echo "processing file $file..." >> $scriptlog 2>&1 
-   runno=`basename $file | cut -d_ -f2`
+   runno=`basename $file | sed -e 's/.*20[01][0-9]\{5\}_\(M[12]_\)\?.*\([0-9]\{8\}\).\([0-9]\{3\}\)\?.*/\2/'`
    query="SELECT fSequenceFirst FROM RunData WHERE fRunNumber="$runno
    echo " sending query: $query" >> $scriptlog 2>&1