How do I change all occurrences of xyz:# to xyzI 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.
ScriptingRe: How do I change all occurrences of xyz:# to xyzWhen you state xyz:# is that literally the value or are you referring to xyz as being a character place holder like
abcd:#
zzqr:#
or are you referring to # as being a numeric place holder like
abcd:123
zzqr:874Re: How do I change all occurrences of xyz:# to xyzXYZ is a placeholder that is referring to what I named the sample. So for example, I analyze a sample that I name "Texas Tea" in triplicate, the program will return the data with the names, "Texas Tea:1, Texas Tea:2, and Texas Tea:3".
