need to remove 'semicolon' which occurs at the end
772180May 27 2010 — edited May 27 2010Hi ,
I have a column (collector_name) where the data is as follows
COLLECTOR_NAME_
To be assigned*;*
Inactive location; to be assigned*;*
To be assigned*;*
Xxxx*;*
ABC; 123*;*
And so on…
I need to remove the seimcolon which occurs at end . How to remove