Removing string after word in filemaker field
I have list of 500,000 terms in a table . Some of them have string of numbers after the trem e.g term1 (001)
trem2 (002) and so on . I want to get rid of the stuff in parenthess. How can I do that ?