Extract part of string before the first semicolon

r string gsub
Sharath picture Sharath · Apr 20, 2015 · Viewed 7.4k times · Source

I have a column containing values of 3 strings separated by semicolons. I need to just extract the part of the string which comes before the first semicolon.

Type <- c("SNSR_RMIN_PSX150Y_CSH;SP_12;I0.00V50HX0HY3000")

What I want is: Get the first part of the string (till the first semicolon).

Desired output : SNSR_RMIN_PSX150Y_CSH

I tried gsub without success.

Answer

akrun picture akrun · Apr 20, 2015

You could try sub

sub(';.*$','', Type)
#[1] "SNSR_RMIN_PSX150Y_CSH"

It will match the pattern i.e. first occurence of ; to the end of the string and replace with ''

Or use

library(stringi)
stri_extract(Type, regex='[^;]*')
#[1] "SNSR_RMIN_PSX150Y_CSH"

Related questions

Remove parenthesis from a character string

I am trying to remove a parenthesis from a string in R and run into the following error: string <- "log(M)" gsub("log", "", string) # Works just fine gsub("log(", "", string) #breaks # Error in gsub("log(", "", test) : # invalid regular …

Read More
Replace multiple strings in one gsub() or chartr() statement in R?

I have a string variable containing alphabet[a-z], space[ ], and apostrophe['],eg. x <- "a'b c" I want to replace apostrophe['] with blank[], and replace space[ ] with underscore[_]. x <- gsub("'", "", x) x <- …

Read More
Removing leading zeros from alphanumeric characters in R

I have a character vector d with alphanumeric characters d <- c("012309 template", "separate 00340", "00045", "890 098", "3405 garage", "matter00908") d [1] "012309 template" "separate 00340" "00045" "890 098" "3405 garage" "matter00908" How can I remove the leading zeros from all the numbers in R? as.numeric will remove all …

Read More