How to strip out common terms in string
Hi,
I have this kinda of data:-
0,0,0,0,1,2,0,4,5,6,7,foo
0,0,0,0,1,4,0,5,5,5,5,foo1
0,0,6,0,1,6,0,6,1,2,3,orange
etc...
I wanted to remove the 0 which occur on the same rows of foo,foo1 and orange in this case.
Desired output is:-
0,1,2,4,5,6,7,foo
0,1,4,5,5,5,5,foo1
6,1,6,6,1,2,3,orange
In other words, those with zeros occuring on all rows, i wanted it to removed from the string. Anyone could advise.
THanks.