Hello!

I am extracting zip codes from the string variable called adr by using the following command:
Code:
generate zip = substr(adr,-5,.)
However, some of the strings have " -" in the end:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str369 adr
"Mountain View Grand Resort & Spa 101 Mountain View Rd, Whitefield, NH 03598"    
"Weathervane Theatre 389 Lancaster Rd, Whitefield, NH 03598"                     
"Mountain View Golf Course 101 Mountain View Rd, Whitefield, NH 03598"           
"Mountain View Grand Resort & Spa 101 Mountain View Rd, Whitefield, NH 03598"    
"Silver Star Spa 6 W 48th St, New York, NY 10036 -"                              
"Red Robin Gourmet Burgers and Brews 18410 33rd Ave W, Lynnwood, WA 98036 -"     
"Guy's American Kitchen & Bar 220 W 44th St, New York, NY 10036 -"               
"Firestone Complete Auto Care 360 W St Georges Ave, Linden, NJ 07036 -"          
"Oasis Massage Salon 9889 Bellaire Blvd #331, Houston, TX 77036 -"               
"Northeast Pediatric Dentistry 11223 Davinci Dr, Davidson, NC 28036 -"           
"Righteous Movers 10333 Harwin Dr, Houston, TX 77036 -"                          
"Consulado Dominicano en Nueva York 1501 Broadway Floor 4r, New York, NY 10036 -"
end
How could I possibly drop these dashes and spaces?

Thankfully,
Anton