Extract string using stringr

Question

I have a string "BTL_OTM_TLS_TTL_ACQ_0.0.0|Fixed" from where I want to extract "BTL_OTM_TLS_TTL_ACQ".

However I am getting "BTL_OTM_TLS_TTL_ACQ" "|". I have used stringr and I have provided the code below. Any help will be greatly appreciated.

> k
[1] "BTL_OTM_TLS_TTL_ACQ_0.0.0|Fixed"
> str_extract(k, "(_)[0-9](.)+")
[1] "_0.0.0|Fixed"
> strsplit(as.character(k),str_extract(as.character(k),"(_)[0-9](.)+"))
[[1]]
[1] "BTL_OTM_TLS_TTL_ACQ" "|"

akrun · Accepted Answer · 2015-04-28 19:37:21Z

6

You can try sub from base R

 sub('_\\d.*', '', k)
 #[1] "BTL_OTM_TLS_TTL_ACQ"

Or using lookarounds with str_extract

 library(stringr)
 str_extract(k, perl('.*(?=_[0-9])'))
 #[1] "BTL_OTM_TLS_TTL_ACQ"

Or

strsplit(k, '_[0-9]+.*$')[[1]]
#[1] "BTL_OTM_TLS_TTL_ACQ"

Update

If we need to extract 0.0.0, one option is

gsub('^[^0-9]*|\\|.*$', '', k)
#[1] "0.0.0"

data

k <- "BTL_OTM_TLS_TTL_ACQ_0.0.0|Fixed"

edited Apr 28, 2015 at 19:37

answered Apr 28, 2015 at 17:09

akrun

891k38 gold badges590 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rajarshi Bhadra Over a year ago

is there any way I can extract 0.0.0 out of the expression??

akrun Over a year ago

Try gsub('^[^0-9]*|\\|.*$', '', k)#[1] "0.0.0"

Collectives™ on Stack Overflow

Extract string using stringr

1 Answer 1

Update

data

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Update

data

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related