Dear all

How can I extract the last word from the variable EntrySector.

For example

"Bangkok - Paro"
"Phuentsholing"
"Phuentsholing"
"Kolkata - Paro"

I want to extract Paro from "Bangkok - Paro" , "Kolkata - Paro" and if its only one word ""Phuentsholing"" extract that word.

An example of my data set

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str28 EntrySector
"Bangkok - Paro"  
"Bangkok - Paro"  
"Bangkok - Paro"  
"Bangkok - Paro"  
"Bangkok - Paro"  
"Phuentsholing"   
"Phuentsholing"   
"Kolkata - Paro"  
"Kolkata - Paro"  
"Delhi - Paro"    
"Bangkok - Paro"  
"Kathmandu - Paro"
"Kathmandu - Paro"
"Phuentsholing"   
"Samdrup Jongkhar"
"Dhaka - Paro"    
"Singapore - Paro"
"Kathmandu - Paro"
"Bangkok - Paro"  
"Kathmandu - Paro"
"Kathmandu - Paro"
"Samdrup Jongkhar"
"Hanoi - Paro"    
"Delhi - Paro"    
"Delhi - Paro"    
"Bangkok - Paro"  
"Delhi - Paro"    
"Kathmandu - Paro"
"Kathmandu - Paro"
"Kathmandu - Paro"
"Hanoi - Paro"    
"Kathmandu - Paro"
"Phuket - Paro"   
"Delhi - Paro"    
"Kathmandu - Paro"
"Kolkata - Paro"  
"Phuentsholing"   
"Bangkok - Paro"  
"Bangkok - Paro"  
"Bangkok - Paro"  
"Delhi - Paro"    
"Kathmandu - Paro"
"Kathmandu - Paro"
"Delhi - Paro"    
"Phuentsholing"   
"Bangkok - Paro"  
"Delhi - Paro"    
"Bangkok - Paro"  
"Kathmandu - Paro"
"Kathmandu - Paro"
"Bangkok - Paro"  
"Bangkok - Paro"  
"Bangkok - Paro"  
"Samdrup Jongkhar"
"Bangkok - Paro"  
"Kolkata - Paro"  
"Bangkok - Paro"  
"Delhi - Paro"    
"Kathmandu - Paro"
"Kathmandu - Paro"
"Kathmandu - Paro"
"Singapore - Paro"
"Kathmandu - Paro"
"Kathmandu - Paro"
"Bangkok - Paro"  
"Kathmandu - Paro"
"Kathmandu - Paro"
"Samdrup Jongkhar"
"Hongkong - Paro" 
"Delhi - Paro"    
"Phuentsholing"   
"Kathmandu - Paro"
"Kathmandu - Paro"
"Kolkata - Paro"  
"Kathmandu - Paro"
"Samdrup Jongkhar"
"Bangkok - Paro"  
"Kathmandu - Paro"
"Kathmandu - Paro"
"Kathmandu - Paro"
"Bangkok - Paro"  
"Delhi - Paro"    
"Kathmandu - Paro"
"Bangkok - Paro"  
"Delhi - Paro"    
"Delhi - Paro"    
"Kathmandu - Paro"
"Kathmandu - Paro"
"Singapore - Paro"
"Kolkata - Paro"  
"Kathmandu - Paro"
"Kathmandu - Paro"
"Kathmandu - Paro"
"Bangkok - Paro"  
"Kathmandu - Paro"
"Bangkok - Paro"  
"Kathmandu - Paro"
"Bangkok - Paro"  
"Kathmandu - Paro"
"Bangkok - Paro"  
end
------------------ copy up to and including the previous line ------------------