[R] Retain last grouping after a strsplit()

Gabor Grothendieck ggrothendieck at gmail.com
Tue Dec 11 20:56:30 CET 2012


On Tue, Dec 11, 2012 at 12:46 PM, Steven Ranney <steven.ranney at gmail.com> wrote:
> 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"

Replace everything up to the last dash with the empty string like this:

sub(".*-", "", data$SiteName)

--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com




More information about the R-help mailing list