Hi

in my dataset, I have a variable called AllAvailableHoldersOwned which states the ownership data of a company. It is already sorted on every line from highest to lowest. All observations look like this:

The Vanguard Group, Inc. (6.88); BlackRock, Inc. (NYSE:BLK) (6.36); Steven M. Rales (6.06); ........

I want to separate the highest ownership percentage from each observation. so for this observation, I would like to generate a variable which states that for this observation the highest ownership is 6.88:

sorry for not including a dataex example. My stata said that the observation has too many characters in them to use the command.

Thanks in advance