Hi, I am struggling with extracting county name from the address using split command.
I am not sure if the split would work for achieving my goal.
Has anyone tried to solve the same issue?

My data looks like this.
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str58 address
"4376 BRYAN STREET  GREENWOOD, FL 32443"              
"8126 HIGHWAY 90  SNEADS, FL 32460"                  
"2110 E INTERNATIONAL SPEEDWAY BLVD  DELAND, FL 32724"
"800 WEST BROADWAY  OVIEDO, FL 32765"                
"4835 S   STATE ROAD 7  FORT LAUDERDALE, FL 33314"    
"1555 CHENEY HWY  TITUSVILLE, FL 32780"              
"7297 RIDGE ROAD  PORT RICHEY, FL 34668"              
"525 E UNIVERSITY BLVD  MELBOURNE, FL 32901"          
"400 EAST STATE ROAD 434  LONGWOOD, FL 32750"        
"3850 N HIGHWAY 19 A  MOUNT DORA, FL 32757"          
"2640 EAST ORANGE  AVENUE  EUSTIS, FL 32726"          
"1377 BRICKYARD ROAD SUITE 5  CHIPLEY, FL 32428"      
"5480 DOGWOOD ST  MILTON, FL 32570"                  
"951 PRIM AVENUE  GRACEVILLE, FL 32440"              
"8303 W ATLANTIC BLVD  CORAL SPRINGS, FL 33071"      
"3515 ELKCAM BOULEVARD  CHIPLEY, FL 32428"            
"100 EAST 10TH STREET  GREENSBORO, FL 32330"          
"35922 HIGHWAY 27 NORTH  HAINES CITY, FL 33844"      
"7050 N CHURCH AVENUE  MULBERRY, FL 33860"            
"7241 STATE ROAD 54  NEW PORT RICHEY, FL 34653"      
end
Ideally, I would like to extract county name as "GREENWOOD", "FORT LAUDERDALE", and "NEW PORT RICHEY"