5 messages · jim holtman, Dimitri Liakhovitski
Hello!
Hope you could help me split the strings.
I have a set of strings:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
I need to extract from each string:
1. Its unique part that comes before the last "_", i.e.: "a1","a2","a3_bla".
2. The part that comes after the last "_" and before ".o" at the end,
i.e.: 2.5, 2.53, 1.
Thank you so much for your help!
Dimitri Liakhovitski marketfusionanalytics.com
try this:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
strsplit(sub(".*?([^_]+)_([^-]+).o$", "\\1 \\2", x), ' ')
[[1]] [1] "a1" "2.5" [[2]] [1] "a2" "2.53" [[3]] [1] "bla" "1"
On Fri, Jul 29, 2011 at 12:08 PM, Dimitri Liakhovitski
Hello!
Hope you could help me split the strings.
I have a set of strings:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
I need to extract from each string:
1. Its unique part that comes before the last "_", i.e.: "a1","a2","a3_bla".
2. The part that comes after the last "_" and before ".o" at the end,
i.e.: 2.5, 2.53, 1.
Thank you so much for your help!
--
Dimitri Liakhovitski
marketfusionanalytics.com
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
Thank you, Jim. It's close but not all the way. The desired result is:
[[1]] [1] "a1" "2.5" [[2]] [1] "a2" "2.53" [[3]] [1] "a3_bla" "1"
Dimitri
try this:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
strsplit(sub(".*?([^_]+)_([^-]+).o$", "\\1 \\2", x), ' ')
[[1]] [1] "a1" ?"2.5" [[2]] [1] "a2" ? "2.53" [[3]] [1] "bla" "1"
On Fri, Jul 29, 2011 at 12:08 PM, Dimitri Liakhovitski <dimitri.liakhovitski at gmail.com> wrote:
Hello!
Hope you could help me split the strings.
I have a set of strings:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
I need to extract from each string:
1. Its unique part that comes before the last "_", i.e.: "a1","a2","a3_bla".
2. The part that comes after the last "_" and before ".o" at the end,
i.e.: 2.5, 2.53, 1.
Thank you so much for your help!
--
Dimitri Liakhovitski
marketfusionanalytics.com
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
Dimitri Liakhovitski marketfusionanalytics.com
But your requirements said "last underscore"; so we now have a change that really says the first underscore. So we change the regex to:
strsplit(sub("[^_]+_(.+)_(.+).o$", "\\1 \\2", x), ' ')
[[1]] [1] "a1" "2.5" [[2]] [1] "a2" "2.53" [[3]] [1] "a3_bla" "1"
On Fri, Jul 29, 2011 at 12:40 PM, Dimitri Liakhovitski
Thank you, Jim. It's close but not all the way. The desired result is:
[[1]] [1] "a1" ?"2.5" [[2]] [1] "a2" ? "2.53" [[3]] [1] "a3_bla" "1"
Dimitri On Fri, Jul 29, 2011 at 12:35 PM, jim holtman <jholtman at gmail.com> wrote:
try this:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
strsplit(sub(".*?([^_]+)_([^-]+).o$", "\\1 \\2", x), ' ')
[[1]] [1] "a1" ?"2.5" [[2]] [1] "a2" ? "2.53" [[3]] [1] "bla" "1"
On Fri, Jul 29, 2011 at 12:08 PM, Dimitri Liakhovitski <dimitri.liakhovitski at gmail.com> wrote:
Hello!
Hope you could help me split the strings.
I have a set of strings:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
I need to extract from each string:
1. Its unique part that comes before the last "_", i.e.: "a1","a2","a3_bla".
2. The part that comes after the last "_" and before ".o" at the end,
i.e.: 2.5, 2.53, 1.
Thank you so much for your help!
--
Dimitri Liakhovitski
marketfusionanalytics.com
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
-- Dimitri Liakhovitski marketfusionanalytics.com
Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
Thanks a lot, Jim! Dimitri
But your requirements said "last underscore"; so we now have a change that really says the first underscore. ?So we change the regex to:
strsplit(sub("[^_]+_(.+)_(.+).o$", "\\1 \\2", x), ' ')
[[1]] [1] "a1" ?"2.5" [[2]] [1] "a2" ? "2.53" [[3]] [1] "a3_bla" "1"
On Fri, Jul 29, 2011 at 12:40 PM, Dimitri Liakhovitski <dimitri.liakhovitski at gmail.com> wrote:
Thank you, Jim. It's close but not all the way. The desired result is:
[[1]] [1] "a1" ?"2.5" [[2]] [1] "a2" ? "2.53" [[3]] [1] "a3_bla" "1"
Dimitri On Fri, Jul 29, 2011 at 12:35 PM, jim holtman <jholtman at gmail.com> wrote:
try this:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
strsplit(sub(".*?([^_]+)_([^-]+).o$", "\\1 \\2", x), ' ')
[[1]] [1] "a1" ?"2.5" [[2]] [1] "a2" ? "2.53" [[3]] [1] "bla" "1"
On Fri, Jul 29, 2011 at 12:08 PM, Dimitri Liakhovitski <dimitri.liakhovitski at gmail.com> wrote:
Hello!
Hope you could help me split the strings.
I have a set of strings:
x<-c("name_a1_2.5.o","name_a2_2.53.o","name_a3_bla_1.o")
I need to extract from each string:
1. Its unique part that comes before the last "_", i.e.: "a1","a2","a3_bla".
2. The part that comes after the last "_" and before ".o" at the end,
i.e.: 2.5, 2.53, 1.
Thank you so much for your help!
--
Dimitri Liakhovitski
marketfusionanalytics.com
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
-- Dimitri Liakhovitski marketfusionanalytics.com
-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
Dimitri Liakhovitski marketfusionanalytics.com