Skip to content
Prev 168507 / 398502 Next

Text data

i have a data column of text entries:
26M_AN_C.bmp
22M_AN_C.bmp
20M_HA_O.bmp
20M_AN_C.bmp
26M_HA_O.bmp
22M_HA_O.bmp
31M_AN_C.bmp
38M_HA_O.bmp
.
.
.
.


And I would like to sort by the middle tag: AN, HA, etc.
Is there a way to parse text data in R? 

In excel, I would have used the "left" and "right" function to cut out just
the middle two letters out and put into another column to sort by. 

Thanks!