I have a variable "company_name" as portion shown below:  I need to extract everything that comes before the first open parenthesis "(" and create either a new variable or frankly just remove all information after the first open paren "(".  Any tips?   CUTWATER SELECT INCOME FUND (RIVUS BOND FUND PRIOR TO 12/2011) US DRY CLEANING CORP (FIRST VIRTUAL COMMUNICATIONS INC PRIOR TO 12/2005) NORDION INC (MDS INC PRIOR TO 11/2010)   Need final variable to look like: CUTWATER SELECT INCOME FUND US DRY CLEANING CORP NORDION INC   Thank you! Matthew ... View more