[R] split a field in dependence of the semicolon

[David Winsemius]

On Nov 3, 2014, at 10:47 AM, Bert Gunter wrote:

> See ?strsplit using the fixed =";" argument on the column containing
> the character vector you wish to split.
> 
> The trickier part is that the result is a list that needs to be
> manipulated -- ?do.call might be useful here, although I haven't
> thought about it seriously -- to build your data frame containing
> missings. There are various ways to do this, but  "An Introduction to
> R" (ships with R) -- you have read it right? -- should provide the
> info you need.
> 
> That should get you started. Others may provide a more complete
> solution, but that's much less fun.

Here's a start using the fill argument to read.table and the 'Members' column as text data:

cbind(dat,  
      read.table(text=as.character(dat$Members), sep=";", fill =TRUE)[-1] )

#----------------------
     ID            Members   V2   V3   V4
1     1    ; abc; def; ghi  abc  def  ghi
2     2             ; abc;  abc          
3     3              ;def;  def     


> 
> Cheers,
> Bert
> 
> Bert Gunter
> Genentech Nonclinical Biostatistics
> (650) 467-7374
> 
> "Data is not information. Information is not knowledge. And knowledge
> is certainly not wisdom."
> Clifford Stoll
> 
> 
> 
> 
> On Mon, Nov 3, 2014 at 8:05 AM, Matthias Weber
> <Matthias.Weber at fntsoftware.com> wrote:
>> 
>> Hello togehter,
>> 
>> i have a little problem, maybe anyone can help me.
>> 
>> I have a data.frame, which look like this one:
>>      ID         Members
>> 1     1         ; abc; def; ghi
>> 2     2         ; abc;
>> 3     3         ;def;
>> 
>> How can I create another column for each value between 2 semicolons?
>> 
>> The result look like this one:
>> 
>>      ID         Members                Member1            Member2             Member3
>> 1     1         ; abc; def; ghi         abc                     def                     ghi
>> 2     2         ; abc;                     abc
>> 3     3         ;def;                      def
>> 
>> Maybe anyone can help me. Thank you.
>> 
>> Best regards.
>> 
>> Mat
>> 
>> 
> 
> ______________________________________________
> 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.

David Winsemius
Alameda, CA, USA