[R] How to replace all commas with semicolon in a string

[Ulrik Stervbo]

If your data.frame is a mix you can loop over each column - along the lines
of:

library(plyr)

adply(test, 2, function(x){
if(!is.numeric(x[[1]]){
gsub(",", ";", x[[1]])
}else{
x[[1]]
}
})

Ulrik

On Fri, 27 May 2016 at 17:21 Jun Shen <jun.shen.ut at gmail.com> wrote:

> Thanks Ulrik and Bob for your reply.
>
> gsub worked for one column!
>
> If I want to replace the whole data frame, gsub doesn't seem to work. Any
> idea
>
> On Fri, May 27, 2016 at 11:14 AM, Ulrik Stervbo <ulrik.stervbo at gmail.com>
> wrote:
>
>> use gsub()
>>
>> On Fri, 27 May 2016 at 17:12 Jun Shen <jun.shen.ut at gmail.com> wrote:
>>
>>> Dear list,
>>>
>>> Say I have a data frame
>>>
>>> test <- data.frame(C1=c('a,b,c,d'),C2=c('g,h,f'))
>>>
>>> I want to replace the commas with semicolons
>>>
>>> sub(',',';',test$C1) -> test$C1 will only replace the first comma of a
>>> string.
>>>
>>> How do I replace them all in one run? Thanks.
>>>
>>> Jun
>>>
>>>         [[alternative HTML version deleted]]
>>>
>>> ______________________________________________
>>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>>> 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]]