[R] Retain last grouping after a strsplit()

Steven Ranney steven.ranney at gmail.com
Tue Dec 11 18:46:56 CET 2012


All -

I have a column of SiteNames:

SiteName
OYS-PIA2-FL-1
OYS-PIA2-LA-1
OYS-PI-LA-BB-1
OYS-PIA2-LA-10
...
[truncated]

and I want to include only the last few digits into a new column.

I tried

substr(data$SiteName, 13, 20)

but because some SiteName values are of a different length, the final
hyphen (i.e., "-") was included:

"1"
"1"
"-1"
"10"
...

 so I use

strsplit(data$SiteName, split = "-")

and get

"OYS" "PIA2" "FL" "1"
"OYS" "PIA2" "LA" "1"
"OYS" "PI" "LA" "BB" "1"
"OYS" "PIA2" "LA" "10"
...

which is great.  Unfortunately, I'm stuck.  I don't know how to
retrieve the final grouping of information from the strsplit()
statement I called into a new column.

Can you help?

Thanks -

SR
Steven H. Ranney



More information about the R-help mailing list