I have multiple data which contains different quantities of leading and trailing colons (as well as colons (
inside the alphanumeric text. I need to remove the leading and trailing colons (
from the text; not from the middle. Some of my data are as follows:
;;;;915531156;898520523;;;;;;;
28tgi11148;954419610;;;;;
542778022;8xtra02;824291991;;;;
;;769982422;550004568;640455606;458632786;;
;769982422;640455606;;;;
I would like to get the output as follows:
915531156;898520523
28tgi11148;954419610
542778022;8xtra02;824291991
769982422;550004568;640455606;458632786
769982422;640455606
Please advice.
Thanks in advance for all your co-operation.
Bookmarks