How to remove specific pattern in string?

Question

I have data in that string is like f <- "./DAYA-1178/10TH FEB.xlsx". I would like to extract only DAYA-1178

what I have tried is

f1 <- gsub(".*./","", f)

But it is giving last result of my file "10TH FEB.xlsx"

Appreciate any lead.

Onyambu · Accepted Answer · 2020-03-03 05:57:56Z

4

It seems you are dealing with files. You need the basename of the directory:

basename(dirname(f))
[1] "DAYA-1178"

or you could do:

sub(".*/","",dirname(f))
[1] "DAYA-1178"

answered Mar 3, 2020 at 5:57

Onyambu

80.3k3 gold badges29 silver badges65 bronze badges

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

Comments

Tim Biegeleisen · Accepted Answer · 2020-03-03 05:42:11Z

1

Using strsplit, we can split the input on path separator / and retain the second element:

f <- "./DAYA-1178/10TH FEB.xlsx"
unlist(strsplit(f, "/"))[2]
[1] "DAYA-1178"

If you wish to use sub, here is one way:

sub("^.*/(.*?)/.*$", "\\1", f)
[1] "DAYA-1178"

answered Mar 3, 2020 at 5:42

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Pragadeesh waran · Accepted Answer · 2020-03-03 06:03:40Z

0

f1 <- gsub("[.,xlsx]","",f)

u can try like these it will give

f1 <- /DAYA-1178/10TH FEB

f3 <- strsplit(f1,"/")[[1]][2]

DAYA-1178 --> answer

answered Mar 3, 2020 at 6:03

Pragadeesh waran

832 silver badges7 bronze badges