| #!/bin/bash | #!/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 | for file in ./*.xls |
| do | do |
| echo "${file}" | echo "${file}" |
| newfile=`sed -n "4p" "${file}" | sed -e "s/\t/^/g" | cut -d"^" -f 4 | cut -d" " -f 1 | sed -e "s/-//g"` | md5=`md5sum "${file}" | cut -d' ' -f 1` |
| mv "${file}" "${newfile}.xls" | 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 | done |