--- a/admin/data/rename.sh
+++ b/admin/data/rename.sh
@@ -1,9 +1,19 @@
 #!/bin/bash
+
+if [[ "$OSTYPE" =~ ^darwin ]]; then
+    alias md5='md5 -r'
+    alias md5sum='md5 -r'
+    # https://sagebionetworks.jira.com/wiki/display/PLFM/Fixing+sed+on+OSx
+    alias sed='gsed'
+fi
 
 for file in ./*.xls
 do
 	echo "${file}"
-	newfile=`sed -n "4p" "${file}" | sed -e "s/\t/^/g" | cut -d"^" -f 4 | cut -d" " -f 1 | sed -e "s/-//g"`
-	mv "${file}" "${newfile}.xls"
+	md5=`md5sum "${file}" | cut -d' ' -f 1`
+	echo "${md5}"
+	newfile=`sed -n "4p" "${file}" | sed -e "s/\t/^/g" | cut -d"^" -f 3 | sed -e "s/=//g" | sed -e 's/"//g'`
+	echo "${newfile}"
+	mv "${file}" "${newfile}.${md5}.xls"
 done