How can I extract text between two strings.
For e.g.:
x <- "ABCDName:Mr.Praveen KumarDOB"
I want to extract Mr. Praveen Kumar.
Also, I want to extract string from starting till it encounters Name:.
Asked
Active
Viewed 480 times
1
zx8754
- 52,746
- 12
- 114
- 209
Bitanshu Das
- 627
- 2
- 8
- 21
-
1similar question: http://stackoverflow.com/questions/17215789/extract-a-substring-in-r-according-to-a-pattern – RetteMich Jul 20 '15 at 11:27
-
4Maybe `strsplit(x, "Name:|DOB")`? – David Arenburg Jul 20 '15 at 11:27
-
This seems very similar to [your other question here](http://stackoverflow.com/questions/31513552/splitting-strings-in-r/31514980#31514980). – Nick Kennedy Jul 20 '15 at 11:40
-
yes...i m trying to find out various methods to do this as my file is very big – Bitanshu Das Jul 20 '15 at 11:43
2 Answers
1
Try
gsub('^[^:]+:|[A-Z]{1,}$', '', x)
#[1] "Mr.Praveen Kumar"
sub('Name.*', '', x)
#[1] "ABCD"
akrun
- 874,273
- 37
- 540
- 662
1
You may try this,
> library(stringr)
> str_extract(x, perl("Name:\\K.*?(?=[A-Z]{2,})"))
[1] "Mr.Praveen Kumar"
> str_extract_all(x, perl("Name:\\K.*?(?=[A-Z]{2,})|.*?(?=Name:)"))[[1]]
[1] "ABCD" "Mr.Praveen Kumar"
Avinash Raj
- 172,303
- 28
- 230
- 274
-
-
1@BitanshuDas In the new stringr, there is no need to wrap with `perl`. Just use without that wrapping and it should work fine. `str_extract_all(x, "Name:\\K.*?(?=[A-Z]{2,})|.*?(?=Name:)")[[1]]` works fine for me – akrun Jul 20 '15 at 11:51