How do I change all occurrences of xyz:# to xyz
I need a script to loop across all character columns and find those who have the pattern xyz:#, and convert to xyz. I have a program that adds a numerical value to each duplicate sample I analyze, however, I recode each duplicate sample name to remove the assigned number as part of my data clean-up. Can this process be scripted? Thank you.