Extracting a portion of data

[matthewF]

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

[Astounding]

company_name = scan(company_name, 1, "(" );