Remove character strings
I have this column SAMPLE where I need only to retain the code inside the () but somehow, I cannot remove the Column% word and the parenthesis. I tried using Word(2,:SAMPLE) but it only returned an error. How to remove the word Column % and the parenthesis from the string?