Hi Statalist,


I have this variable:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str48 assets_total
".......1.40e+07..1.40e+07.1.40e+07......."
".........2977715..2977715.2977715....."   
"4971933..................."               
"........2415713..2415713.2415713......"   
"......1097437..1097437.1097437........"   
".......20781..20781.20781......."         
"........1433721..1433721.1433721......"   
".......723056..723056.723056......."      
"..1.26e+07..1.26e+07.1.26e+07............"
"........542228..542228.542228......"      
".......8996319..8996319.8996319......."   
"........1.33e+07..1.33e+07.1.33e+07......"
".....595979..595979.595979........."      
"........877995..877995.877995......"      
".........662573..662573.662573....."      
".........296659..296659.296659....."      
"....5659386..5659386.5659386.........."   
".....140703..140703.140703........."      
".....9791801..9791801.9791801........."   
".......361970..361970.361970......."      
end
I want to keep only one value in each observation so the "." and the duplicate is removed. So for example the first observation would be: 1.40e+07.

Hope you can help