Another option would be to use -split-
drop _all
input str63 company
"OnlineChoice.com, Inc. (Exelon Corporation (NYSE:EXC))"
"Peppers & Rogers Group (TeleTech Holdings Inc. (NasdaqGS:TTEC))"
end
split company, gen(company) p("(")
split company3, gen(ticker) p(":")
replace ticker2 = subinstr(ticker2, "))", "",.)
drop company3
list
Scott
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/
