Sorting a vector of mixed values (i.e. sort string on number then character)

Asked Jul 24 '19 at 14:01

Active Jul 24 '19 at 21:08

Viewed 30 times

I'm trying to sort the following vector of characters based on 1) numbers and 2) characters:

"BLH-07", "BLH-08", "AFH-08", "AFH-09"

I've tried to use mixedsort, however it doesn't work at present.

library(gtools)
vector = c("BLH-07", "BLH-08", "AFH-08", "AFH-09")
sort = mixedsort(vector, decreasing = TRUE)

My result:

"BLH-07", "BLH-08", "AFH-08", "AFH-09"

Desired result:

"BLH-07", "AFH-08", "BLH-08", "AFH-09"

-> Thus, sorting first on the numbers in the string, and next alphabetically on BLH, AFH...

edited Jul 24 '19 at 21:08

Matt

asked Jul 24 '19 at 14:01

random_user_567

1

Try to split and then do the order `vector[order(as.numeric(gsub("\\D+", "", vector)), gsub("\\d+", "", vector), decreasing = TRUE)]` – akrun Jul 24 '19 at 14:04
1

thanks @akrun! That works – random_user_567 Jul 24 '19 at 14:08

0 Answers0