normalize funny aws values before sorting (for sync compare purposes)