Hi guys, Below is a sample of my data. I would like to remove the "-TOT RETURN IND" in all the observations and just remain with company names. How can i do it in Stata?



Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str64(v title) float date
"4088.75"           "COML.INTL.BANK (EGYPT) - TOT RETURN IND" 20422
"1561.75"           "COML.INTL.BANK (EGYPT) - TOT RETURN IND" 17562
"1195.18"           "COML.INTL.BANK (EGYPT) - TOT RETURN IND" 17773
"NA"                "COML.INTL.BANK (EGYPT) - TOT RETURN IND" 11410
"2575.26"           "COML.INTL.BANK (EGYPT) - TOT RETURN IND" 19662
"NA"                "ELBARBARY INVESTMENT - TOT RETURN IND" 11837
"109.87"            "ELBARBARY INVESTMENT - TOT RETURN IND" 14301
"12303.07"          "ELBARBARY INVESTMENT - TOT RETURN IND" 21882
"136.44"            "ELBARBARY INVESTMENT - TOT RETURN IND" 15155
"159.13"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 14640
"3917.83"           "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 19935
"123.09"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 15673
"NA"                "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 10988
"NA"                "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 12387
"371.54"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 16373
"2153.2"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 19600
"143.44"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 14578
"NA"                "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 11016
"1482.72"           "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 18931
"NA"                "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 13208
"NA"                "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 12537
"128.69"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 13999
"244.76"            "EMAAR MISR FOR DEVELOPMENT - TOT RETURN IND" 16222
"5347.48"           "FIRST INVST & REAL EST - TOT RETURN IND" 20237
"1419.4"            "FIRST INVST & REAL EST - TOT RETURN IND" 19144
"1040.01"           "FIRST INVST & REAL EST - TOT RETURN IND" 18991
"2206.94"           "FIRST INVST & REAL EST - TOT RETURN IND" 19509
"5078.67"           "FIRST INVST & REAL EST - TOT RETURN IND" 20118
"140.4"             "FIRST INVST & REAL EST - TOT RETURN IND" 13969
"1822.18"           "FIRST INVST & REAL EST - TOT RETURN IND" 18443
"122.05"            "FIRST INVST & REAL EST - TOT RETURN IND" 14853
"123.43"            "FIRST INVST & REAL EST - TOT RETURN IND" 15187
"124.9"             "FIRST INVST & REAL EST - TOT RETURN IND" 14973
end
format %td date