> I have the following character field: > > x > ----------- > "5 (59.1)" > "55 (100.0)" > "64 (34.3)" > > The number in parentheses is the percentage. I would like to > remove it so > I get the following in a new field, y. > > y > ---- > "5" > "55" > "64" > > What is the best way to do this?

Key on the left parentheses using the index function, get a substring of x based on that.

y=substr(x,1,index(x,"(")-2));

-Brad