Re: [R] gsub and regex to tidy comma-limited values

with the example below, i think the following solves your problem: text = ',,,apple,,orange,lemon,strawberry' gsub('^,+|,+(?=,)|,+$', '', text, perl=TRUE) vQ Tom wrote: > sub(",$","",gsub("^,*|,*$|(,)*", "\\1", > ",,,apple,,orange,lemon,strawberry")) > > It may not be the

Re: [R] gsub and regex to tidy comma-limited values

sub(",$","",gsub("^,*|,*$|(,)*", "\\1", ",,,apple,,orange,lemon,strawberry")) It may not be the best solution, but it was my first thought Tom - Original Message - From: "Daren Tan" To: Sent: Saturday, March 14, 2009 6:42 PM Subject: [R] gsub and regex to tidy comma-limited

Re: [R] gsub and regex to tidy comma-limited values

Add perl = TRUE On Sat, Mar 14, 2009 at 5:42 AM, Daren Tan wrote: > I am cleaning up comma-limited values, so that only one comma > separates each value. Using the example below, as much as I try with > regex, I can't remove the last comma. I hope to have a one-liner > solution, if possible. > >