Hi Martin,
Here is a sugestion:
string <- c("xy_100_ab", "xy_101_ab","xy_102_ab","xy_103_ab")
out <- data.frame( do.call( rbind, strsplit( string, '_' ) ) )
names(out) <- paste('column',1:3,sep="")
out
HTH,
Jorge
On Tue, Feb 9, 2010 at 6:46 PM, Martin Batholdy <> wrote:
> hi,
>
> I have a vector full of strings like;
>
>
> xy_100_ab xy_101_ab xy_102_ab xy_103_ab
>
>
> I want to seperate each string in three pieces and the separator should be
> the "_"
>
> at the end I want a data.frame like:
>
> column1 column2 column3
> xy 100 ab
> xy 101 ab
> xy 102 ab
> xy 103 ab
>
>
> I tried strsplit but I couldn't figure out how to convert the list I get
> into a data.frame.
>
> I just need a function like read.table. But it seems that read.table only
> can handle files, not vectors...
> ______________________________________________
> [email protected] 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.
>
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.