Shell Programming and Scripting

$ awk -F- '{X=$3; sub (/(\.[A-z]*)*$/, "", X); gsub (/\./," ",X);print $0, $1, $2, X}' file |sort  -k2,3 -k4,4nr -k5,5nr -k6,6nr | sort -u -t- -k1,2 | cut -d" " -f1
alphaData1-1.2.3-2.0.2.mel.au.data
graphicData1-1.2.3-2.0.2.mel.au.data
graphicData1-1.2.5-2.0.2.22.mel.au.data
graphicData2-1.0-1.2.mel.au.data
numericData1-1.2.3-2.20.2.mel.au.data

#!/bin/ksh
tmp="rm_tmp1.$$"        # tmp file to hold sorted ouput list of normalized
                        # dataName-versionNumber-releaseNumber-inputLine records
tmp2="rm_tmp2.$$"       # tmp file to hold rm commands to be executed
ls *.data | awk -F- -v tmp="$tmp" -v tmp2="$tmp2" '
BEGIN { # Create the sort command to be used to sort in reverse order with
        # keys: dataName, versionNumber, and releaseNumber
        cmd = "sort -t- -r -k1,3 > " tmp
}
{       # Split the versionNumber into its components:
        vc = split($2, v, /[.]/)
        # Split the releaseNumber into its components:
        rc = split($3, r, /[.]/)
        # Save the input filename
        il[NR] = $0
        # Create the normalized sort keys:
        #       dataName-versionNumber-releaseNumber-inputLine
        # where each component of versionNumber and releaseNumber has been
        # expnded to 5 decimal digits with leading zero fill, and feed them
        # into the sort command to be sorted into reverse order.
        o = sprintf("%s-%05d", $1, v[1])
        for(i = 2; i <= vc; i++)
                o = sprintf("%s.%05d", o, v[i])
        o = sprintf("%s-%05d", o, r[1])
        for(i = 2; i <= rc - 3; i++) # -3 skips ".cityCode.countryCode.data"
                o = sprintf("%s.%05d", o, r[i])
        printf("%s-%d\n", o, NR) | cmd
}
END {   # Close output to the sort command:
        close(cmd)
        # Read the sorted list of normalized filenames:
        while((rc = (getline < tmp)) == 1) {
                if($1"-"$2 != last) {
                        # This is a new dataName-versionNumber combination.
                        if(nnl) {
                                # Add a newline to the command file.
                                printf("\n") > tmp2
                                nnl = 0
                        }
                        # Save the new dataName-versionNumber and report the
                        # combination we are now processing
                        last = $1"-"$2
                        printf("Processing %s:\nkeeping \"%s\"\n", last, il[$4])
                } else {# We have seen this dataName-versionNumber before
                        # Report that the corresponding file will be removed
                        printf("discarding \"%s\"\n", il[$4])
                        if(nnl) # Add the corresponding file to the list to be
                                # removed for this dataName-versionNumber pair.
                                printf(" \"%s\"", il[$4]) > tmp2
                        else {  # This is the first file that needs to be
                                # removed for this dataName-versionNumber pair
                                printf("echo rm \"%s\"", il[$4]) > tmp2
                                # Note that we will need to add a newline after
                                # we have added the last entry for this pair
                                nnl = 1
                        }
                }
        }
        # Add final newline, if needed
        if(nnl) printf("\n") > tmp2
        # If we hit EOF on sorted temp file, we are done
        if(rc == 0) exit 0
        # Otherwise, print a diagnostic and exit with a non-zero exit status
        printf("I/O error while reading sorted list from %s\n", tmp)
        exit 1
}'
if [ $? -eq 0 ]
then    # awk completed successfully, run the commands to remove old
        # releaseNumber files
        if [ ! -e $tmp2 ]
        then    # No files found to be removed.
                printf "No unneeded versionNumber files found.\n"
                exit 0
        fi
        if sh < $tmp2
        then    # Successful completion, remove temp files and exit
                rm $tmp $tmp2
                printf "Discarded files soccessfully, temp files removed.\n"
                exit 0
        fi
fi
# Otherwise, print diagnostic and quit (saving temp files in place
printf "Some files not removed; temp files:\n\t%s\n\t%s\nsaved.\n" $tmp $tmp2 >&2
exit 1