splitting Chinese addresses?

[River Huang]

Dear All, Suppose that I have the following addresses (in Chinese),

* Example generated by -dataex-. For more info, type help dataex
clear
input str144 t_addr2
"彰化市曉陽路301巷6弄10號"                                                             
"台中市台灣大道三段251號9樓"                                                         
"500 彰化縣 彰化市 長順街141巷14號-假日配送無電鈴到貨請打0973221508感謝"
"302 新竹縣竹北市文興路一段372號"                                                   
"900 屏東縣 屏東市 公勇路83號8樓之1"                                                
end

I uses the code

gen zipcode = ustrregexs(1) if ustrregexm(t_addr2,"^([0-9]*)(.*市|.*縣)?(.*市|.*區)?")
gen city = ustrregexs(2) if ustrregexm(t_addr2,"^([0-9]*)(.*市|.*縣)?(.*市|.*區)?")
gen city2 = ustrregexs(3) if ustrregexm(t_addr2,"^([0-9]*)(.*市|.*縣)?(.*市|.*區)?")

with results

* Example generated by -dataex-. For more info, type help dataex
clear
input str13 zipcode str81 city str91 city2
""    "彰化市"            ""         
""    "台北市"            "內湖區"
"500" " 彰化縣 彰化市" ""         
"302" " 新竹縣竹北市"  ""         
"900" " 屏東縣 屏東市" ""         
end

However, the desired results are

* Example generated by -dataex-. For more info, type help dataex
clear
input str13 zipcode str81 city str91 city2
""    "彰化市"  ""         
""    "台北市"  "內湖區"
"500" " 彰化縣" "彰化市"
"302" " 新竹縣" "竹北市"
"900" " 屏東縣" "屏東市"
end

Any suggestions? Thanks.

[Andrew Musau]

I do not see the word area ("區") in your second observation. You can reverse the order of characters:

* Example generated by -dataex-. For more info, type help dataex
clear
input str144 t_addr2
"彰化市曉陽路301巷6弄10號"                                                            
"台中市台灣大道三段251號9樓"                                                        
"500 彰化縣 彰化市 長順街141巷14號-假日配送無電鈴到貨請打0973221508感謝"
"302 新竹縣竹北市文興路一段372號"                                                  
"900 屏東縣 屏東市 公勇路83號8樓之1"                                                
end

gen city = ustrregexra(t_addr2,"^([0-9]*)(.*縣|.*市)?(.*)?", "$2")
gen city2= ustrregexra(t_addr2,"^([0-9]*)(.*縣|.*市)?(.*區|.*市)?(.*)?", "$3")

Res.:

. l city*

     +-------------------+
     |    city     city2 |
     |-------------------|
  1. |  彰化市           |
  2. |  台中市           |
  3. |  彰化縣    彰化市 |
  4. |  新竹縣    竹北市 |
  5. |  屏東縣    屏東市 |
     +-------------------+

[River Huang]

Dear Andrew, Thanks for the reply. Here is the (more representative) data:

* Example generated by -dataex-. For more info, type help dataex
clear
input str144 t_addr2
"彰化市曉陽路301巷6弄10號"                                                            
"台中市台灣大道三段251號9樓"                                                        
"台北市內湖區潭美街337號3樓"                                                        
"500 彰化縣 彰化市 長順街141巷14號-假日配送無電鈴到貨請打0973221508感謝"
"302 新竹縣竹北市文興路一段372號"                                                  
"900 屏東縣 屏東市 公勇路83號8樓之1"                                                
end

The whole (first-tier city) 縣 or 市 list in Taiwan is:

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 city
"臺北市"
"臺中市"
"基隆市"
"臺南市"
"高雄市"
"新北市"
"宜蘭縣"
"桃園市"
"嘉義市"
"新竹縣"
"苗栗縣"
"南投縣"
"彰化縣"
"新竹市"
"雲林縣"
"嘉義縣"
"屏東縣"
"花蓮縣"
"臺東縣"
"金門縣"
"澎湖縣"
"連江縣"
end

In other words, the new variable city (in the first data set) must be one of those, if not missing. Usually, the second-tier city is "區" after first-tier city "市" and "市 or 鄉 or 鎮" after first-tier city "縣"。
For example, both observations 1 and 4 are from 彰化縣 彰化市, although the first observation does not have 彰化縣 (missing first-tier city information)。I wonder of you can help on this? Thanks.

[Andrew Musau]

Does this get you what you want? Please explain if not.

* Example generated by -dataex-. For more info, type help dataex
clear
input str144 t_addr2
"彰化市曉陽路301巷6弄10號"                                                            
"台中市台灣大道三段251號9樓"                                                        
"台北市內湖區潭美街337號3樓"                                                        
"500 彰化縣 彰化市 長順街141巷14號-假日配送無電鈴到貨請打0973221508感謝"
"302 新竹縣竹北市文興路一段372號"                                                  
"900 屏東縣 屏東市 公勇路83號8樓之1"                                                
end
gen city = ustrregexra(t_addr2,"^([0-9]*)(.*縣|.*市)?(.*)?", "$2")
gen city2= ustrregexra(t_addr2,"^([0-9]*)(.*縣|.*市)?(.*區|.*市|.*鄉|.*鎮)?(.*)?", "$3")

Res.:

. l city*, sep(0)

     +-------------------+
     |    city     city2 |
     |-------------------|
  1. |  彰化市           |
  2. |  台中市           |
  3. |  台北市    內湖區 |
  4. |  彰化縣    彰化市 |
  5. |  新竹縣    竹北市 |
  6. |  屏東縣    屏東市 |
     +-------------------+

.

[River Huang]

Dear Andrew, Not exactly. The first observation should be

. list city*, sep(0)

     +-------------------+
     |    city     city2 |
     |-------------------|
  1. |  彰化市    彰化市 |
  2. |  台中市           |
  3. |  台北市    內湖區 |
  4. |  彰化縣    彰化市 |
  5. |  新竹縣    竹北市 |
  6. |  屏東縣    屏東市 |
     +-------------------+

. list city*, sep(0)

     +-------------------+
     |    city     city2 |
     |-------------------|
  1. |  彰化市    彰化市 |
  2. |  台中市           |
  3. |  台北市    內湖區 |
  4. |  彰化縣    彰化市 |
  5. |  新竹縣    竹北市 |
  6. |  屏東縣    屏東市 |
     +-------------------+

. replace city = "" in 1
(1 real change made)

. list city*, sep(0)

     +-------------------+
     |    city     city2 |
     |-------------------|
  1. |            彰化市 |
  2. |  台中市           |
  3. |  台北市    內湖區 |
  4. |  彰化縣    彰化市 |
  5. |  新竹縣    竹北市 |
  6. |  屏東縣    屏東市 |
     +-------------------+

If the address of the first observation were complete, we should obtain the city/city2 as the fourth observation. Unfortunately, the city (彰化縣) is missing for the first observation. That is the reason I provided the "whole" list for the city variable to check whether the "city" is missing from each address. Any thought? Thanks.

[Chul Lee]

The first row in your original post doesn't have 'city 2' and I believe Andrew did correct job. Would you explain more about your address system? Is this what you need: "to check whether the "city" is missing from each address"?
C

"彰化市曉陽路301巷6弄10號"

[River Huang]

Dear Chul, Thank you for the question. The problem here is that the addresses recorded are sometimes "IMCOMPLETELY". Some without "county" (縣, 市) names, some without "town" (市, 鄉, 鎮) names, and some without both. In the case (first observation) above, the complete address should be "彰化縣彰化市曉陽路301巷6弄10號" instead of "彰化市曉陽路301巷6弄10號". I believe we need the "complete list" of counties (as above)

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 county
"南投縣"
"嘉義市"
"嘉義縣"
"基隆市"
"宜蘭縣"
"屏東縣"
"彰化縣"
"新北市"
"新竹市"
"新竹縣"
"桃園市"
"澎湖縣"
"臺中市"
"臺北市"
"臺南市"
"臺東縣"
"花蓮縣"
"苗栗縣"
"連江縣"
"金門縣"
"雲林縣"
"高雄市"
end

and a "complete lest" of countries and towns

* Example generated by -dataex-. For more info, type help dataex
clear
input str21 countytown
"南投縣中寮鄉"   
"南投縣仁愛鄉"   
"南投縣信義鄉"   
"南投縣南投市"   
"南投縣名間鄉"   
"南投縣國姓鄉"   
"南投縣埔里鎮"   
"南投縣水里鄉"   
"南投縣竹山鎮"   
"南投縣草屯鎮"   
"南投縣集集鎮"   
"南投縣魚池鄉"   
"南投縣鹿谷鄉"   
"嘉義市東區"      
"嘉義市西區"      
"嘉義縣中埔鄉"   
"嘉義縣六腳鄉"   
"嘉義縣大埔鄉"   
"嘉義縣大林鎮"   
"嘉義縣太保市"   
"嘉義縣布袋鎮"   
"嘉義縣新港鄉"   
"嘉義縣朴子市"   
"嘉義縣東石鄉"   
"嘉義縣梅山鄉"   
"嘉義縣民雄鄉"   
"嘉義縣水上鄉"   
"嘉義縣溪口鄉"   
"嘉義縣番路鄉"   
"嘉義縣竹崎鄉"   
"嘉義縣義竹鄉"   
"嘉義縣阿里山鄉"
"嘉義縣鹿草鄉"   
"基隆市七堵區"   
"基隆市中山區"   
"基隆市中正區"   
"基隆市仁愛區"   
"基隆市信義區"   
"基隆市安樂區"   
"基隆市暖暖區"   
"宜蘭縣三星鄉"   
"宜蘭縣五結鄉"   
"宜蘭縣冬山鄉"   
"宜蘭縣南澳鄉"   
"宜蘭縣員山鄉"   
"宜蘭縣壯圍鄉"   
"宜蘭縣大同鄉"   
"宜蘭縣宜蘭市"   
"宜蘭縣礁溪鄉"   
"宜蘭縣羅東鎮"   
"宜蘭縣蘇澳鎮"   
"宜蘭縣頭城鎮"   
"屏東縣三地門鄉"
"屏東縣九如鄉"   
"屏東縣佳冬鄉"   
"屏東縣來義鄉"   
"屏東縣內埔鄉"   
"屏東縣南州鄉"   
"屏東縣屏東市"   
"屏東縣崁頂鄉"   
"屏東縣恆春鎮"   
"屏東縣新園鄉"   
"屏東縣新埤鄉"   
"屏東縣春日鄉"   
"屏東縣東港鎮"   
"屏東縣枋寮鄉"   
"屏東縣枋山鄉"   
"屏東縣林邊鄉"   
"屏東縣泰武鄉"   
"屏東縣滿州鄉"   
"屏東縣潮州鎮"   
"屏東縣牡丹鄉"   
"屏東縣獅子鄉"   
"屏東縣琉球鄉"   
"屏東縣瑪家鄉"   
"屏東縣竹田鄉"   
"屏東縣萬丹鄉"   
"屏東縣萬巒鄉"   
"屏東縣車城鄉"   
"屏東縣里港鄉"   
"屏東縣長治鄉"   
"屏東縣霧臺鄉"   
"屏東縣高樹鄉"   
"屏東縣鹽埔鄉"   
"屏東縣麟洛鄉"   
"彰化縣二林鎮"   
"彰化縣二水鄉"   
"彰化縣伸港鄉"   
"彰化縣北斗鎮"   
"彰化縣和美鎮"   
"彰化縣員林市"   
"彰化縣埔心鄉"   
"彰化縣埔鹽鄉"   
"彰化縣埤頭鄉"   
"彰化縣大城鄉"   
"彰化縣大村鄉"   
"彰化縣彰化市"   
"彰化縣永靖鄉"   
"彰化縣溪州鄉"   
"彰化縣溪湖鎮"   
"彰化縣田中鎮"   
"彰化縣田尾鄉"   
"彰化縣社頭鄉"   
"彰化縣福興鄉"   
"彰化縣秀水鄉"   
"彰化縣竹塘鄉"   
"彰化縣線西鄉"   
"彰化縣芬園鄉"   
"彰化縣花壇鄉"   
"彰化縣芳苑鄉"   
"彰化縣鹿港鎮"   
"新北市三峽區"   
"新北市三芝區"   
"新北市三重區"   
"新北市中和區"   
"新北市五股區"   
"新北市八里區"   
"新北市土城區"   
"新北市坪林區"   
"新北市平溪區"   
"新北市新店區"   
"新北市新莊區"   
"新北市板橋區"   
"新北市林口區"   
"新北市樹林區"   
"新北市永和區"   
"新北市汐止區"   
"新北市泰山區"   
"新北市淡水區"   
"新北市深坑區"   
"新北市烏來區"   
"新北市瑞芳區"   
"新北市石碇區"   
"新北市石門區"   
"新北市萬里區"   
"新北市蘆洲區"   
"新北市貢寮區"   
"新北市金山區"   
"新北市雙溪區"   
"新北市鶯歌區"   
"新竹市北區"      
"新竹市東區"      
"新竹市香山區"   
"新竹縣五峰鄉"   
"新竹縣北埔鄉"   
"新竹縣寶山鄉"   
"新竹縣尖石鄉"   
"新竹縣峨眉鄉"   
"新竹縣新埔鎮"   
"新竹縣新豐鄉"   
"新竹縣橫山鄉"   
"新竹縣湖口鄉"   
"新竹縣竹北市"   
"新竹縣竹東鎮"   
"新竹縣芎林鄉"   
"新竹縣關西鎮"   
"桃園市中壢區"   
"桃園市八德區"   
"桃園市大園區"   
"桃園市大溪區"   
"桃園市平鎮區"   
"桃園市復興區"   
"桃園市新屋區"   
"桃園市桃園區"   
"桃園市楊梅區"   
"桃園市蘆竹區"   
"桃園市觀音區"   
"桃園市龍潭區"   
"桃園市龜山區"   
"澎湖縣七美鄉"   
"澎湖縣望安鄉"   
"澎湖縣湖西鄉"   
"澎湖縣白沙鄉"   
"澎湖縣西嶼鄉"   
"澎湖縣馬公市"   
"臺中市中區"      
"臺中市北區"      
"臺中市北屯區"   
"臺中市南區"      
"臺中市南屯區"   
"臺中市后里區"   
"臺中市和平區"   
"臺中市外埔區"   
"臺中市大安區"   
"臺中市大甲區"   
"臺中市大肚區"   
"臺中市大里區"   
"臺中市大雅區"   
"臺中市太平區"   
"臺中市新社區"   
"臺中市東勢區"   
"臺中市東區"      
"臺中市梧棲區"   
"臺中市沙鹿區"   
"臺中市清水區"   
"臺中市潭子區"   
"臺中市烏日區"   
"臺中市石岡區"   
"臺中市神岡區"   
"臺中市西區"      
"臺中市西屯區"   
"臺中市豐原區"   
"臺中市霧峰區"   
"臺中市龍井區"   
"臺北市中山區"   
"臺北市中正區"   
"臺北市信義區"   
"臺北市內湖區"   
"臺北市北投區"   
"臺北市南港區"   
"臺北市士林區"   
"臺北市大同區"   
"臺北市大安區"   
"臺北市文山區"   
"臺北市松山區"   
"臺北市萬華區"   
"臺南市七股區"   
"臺南市下營區"   
"臺南市中西區"   
"臺南市仁德區"   
"臺南市佳里區"   
"臺南市六甲區"   
"臺南市北區"      
"臺南市北門區"   
"臺南市南化區"   
"臺南市南區"      
"臺南市善化區"   
"臺南市大內區"   
"臺南市學甲區"   
"臺南市安南區"   
"臺南市安定區"   
"臺南市安平區"   
"臺南市官田區"   
"臺南市將軍區"   
"臺南市山上區"   
"臺南市左鎮區"   
"臺南市後壁區"   
"臺南市新化區"   
"臺南市新市區"   
"臺南市新營區"   
"臺南市東區"      
"臺南市東山區"   
"臺南市柳營區"   
"臺南市楠西區"   
"臺南市歸仁區"   
"臺南市永康區"   
"臺南市玉井區"   
"臺南市白河區"   
"臺南市西港區"   
"臺南市關廟區"   
"臺南市鹽水區"   
"臺南市麻豆區"   
"臺南市龍崎區"   
"臺東縣卑南鄉"   
"臺東縣大武鄉"   
"臺東縣太麻里鄉"
"臺東縣延平鄉"   
"臺東縣成功鎮"   
"臺東縣東河鄉"   
"臺東縣池上鄉"   
"臺東縣海端鄉"   
"臺東縣綠島鄉"   
"臺東縣臺東市"   
"臺東縣蘭嶼鄉"   
"臺東縣達仁鄉"   
"臺東縣金峰鄉"   
"臺東縣長濱鄉"   
"臺東縣關山鎮"   
"臺東縣鹿野鄉"   
"花蓮縣光復鄉"   
"花蓮縣卓溪鄉"   
"花蓮縣吉安鄉"   
"花蓮縣壽豐鄉"   
"花蓮縣富里鄉"   
"花蓮縣新城鄉"   
"花蓮縣玉里鎮"   
"花蓮縣瑞穗鄉"   
"花蓮縣秀林鄉"   
"花蓮縣花蓮市"   
"花蓮縣萬榮鄉"   
"花蓮縣豐濱鄉"   
"花蓮縣鳳林鎮"   
"苗栗縣三灣鄉"   
"苗栗縣三義鄉"   
"苗栗縣公館鄉"   
"苗栗縣卓蘭鎮"   
"苗栗縣南庄鄉"   
"苗栗縣大湖鄉"   
"苗栗縣後龍鎮"   
"苗栗縣泰安鄉"   
"苗栗縣獅潭鄉"   
"苗栗縣竹南鎮"   
"苗栗縣苑裡鎮"   
"苗栗縣苗栗市"   
"苗栗縣西湖鄉"   
"苗栗縣通霄鎮"   
"苗栗縣造橋鄉"   
"苗栗縣銅鑼鄉"   
"苗栗縣頭份市"   
"苗栗縣頭屋鄉"   
"連江縣北竿鄉"   
"連江縣南竿鄉"   
"連江縣東引鄉"   
"連江縣莒光鄉"   
"金門縣烈嶼鄉"   
"金門縣烏坵鄉"   
"金門縣金城鎮"   
"金門縣金寧鄉"   
"金門縣金沙鎮"   
"金門縣金湖鎮"   
"雲林縣二崙鄉"   
"雲林縣元長鄉"   
"雲林縣北港鎮"   
"雲林縣口湖鄉"   
"雲林縣古坑鄉"   
"雲林縣四湖鄉"   
"雲林縣土庫鎮"   
"雲林縣大埤鄉"   
"雲林縣崙背鄉"   
"雲林縣斗六市"   
"雲林縣斗南鎮"   
"雲林縣東勢鄉"   
"雲林縣林內鄉"   
"雲林縣水林鄉"   
"雲林縣臺西鄉"   
"雲林縣莿桐鄉"   
"雲林縣虎尾鎮"   
"雲林縣褒忠鄉"   
"雲林縣西螺鎮"   
"雲林縣麥寮鄉"   
"高雄市三民區"   
"高雄市仁武區"   
"高雄市內門區"   
"高雄市六龜區"   
"高雄市前金區"   
"高雄市前鎮區"   
"高雄市南沙群島"
"高雄市大寮區"   
"高雄市大樹區"   
"高雄市大社區"   
"高雄市小港區"   
"高雄市岡山區"   
"高雄市左營區"   
"高雄市彌陀區"   
"高雄市新興區"   
"高雄市旗山區"   
"高雄市旗津區"   
"高雄市杉林區"   
"高雄市東沙群島"
"高雄市林園區"   
"高雄市桃源區"   
"高雄市梓官區"   
"高雄市楠梓區"   
"高雄市橋頭區"   
"高雄市永安區"   
"高雄市湖內區"   
"高雄市燕巢區"   
"高雄市田寮區"   
"高雄市甲仙區"   
"高雄市美濃區"   
"高雄市苓雅區"   
"高雄市茂林區"   
"高雄市茄萣區"   
"高雄市路竹區"   
"高雄市那瑪夏區"
"高雄市阿蓮區"   
"高雄市鳥松區"   
"高雄市鳳山區"   
"高雄市鹽埕區"   
"高雄市鼓山區"   
end

I hope these extra informarion is useful for you and Andrew to understand my question. Thanks

[Andrew Musau]

Thanks for the extra details. I would use the list of counties to extract the counties and thereafter use a regular expression to extract the towns. One issue is that a county can be written differently, e.g., 台中市 or 臺中市 and 台北市 or 臺北市. Make sure that you account for these differences. I do so by including both versions in your county list.

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 county
"臺北市"
"台北市"
"臺中市"
"台中市"
"基隆市"
"臺南市"
"高雄市"
"新北市"
"宜蘭縣"
"桃園市"
"嘉義市"
"新竹縣"
"苗栗縣"
"南投縣"
"彰化縣"
"新竹市"
"雲林縣"
"嘉義縣"
"屏東縣"
"花蓮縣"
"臺東縣"
"金門縣"
"澎湖縣"
"連江縣"
end

levelsof county, local(counties) sep(|) clean

* Example generated by -dataex-. For more info, type help dataex
clear
input str144 t_addr2
"彰化市曉陽路301巷6弄10號"                                                            
"台中市台灣大道三段251號9樓"                                                        
"台北市內湖區潭美街337號3樓"                                                        
"500 彰化縣 彰化市 長順街141巷14號-假日配送無電鈴到貨請打0973221508感謝"
"302 新竹縣竹北市文興路一段372號"                                                  
"900 屏東縣 屏東市 公勇路83號8樓之1"                                                
end

gen county = ustrregexs(0) if ustrregexm(" " + t_addr2 + " ", "(`counties')")
gen town= ustrregexra(ustrregexra(t_addr2, county, "", 1), "^([0-9]*)(.*區|.*市|.*鄉|.*鎮)?(.*)?", "$2")

Res.:

. l county town, sep(0)

     +-------------------+
     | county       town |
     |-------------------|
  1. |            彰化市 |
  2. | 台中市            |
  3. | 台北市     內湖區 |
  4. | 彰化縣     彰化市 |
  5. | 新竹縣     竹北市 |
  6. | 屏東縣     屏東市 |
     +-------------------+

[River Huang]

Dear Andrew, Thanks for this helpful suggestion. May I know the idea of

 " " + t_addr2 + " "

What do empty spaces and + signs mean? Thanks.

[River Huang]

Dear Andrew, A probably more difficult question. The data is

* Example generated by -dataex-. For more info, type help dataex
clear
input str144 t_addr2
"台北市市民大道三段2號5樓"                          
"台北市南港區園區街3之1號G棟8樓"                  
"508 彰化縣 和美鎮 西鄉路161巷2號"                  
"302 新竹縣竹北市文興路一段372號"                  
"320 桃園市 中壢區 桃園市中壢區中山路201號4樓"
end

The desired result is

* Example generated by -dataex-. For more info, type help dataex
clear
input str1 county str22(town road)
"台北市" ""          "市民大道"
"台北市" "南港區" "園區街"   
"彰化縣" "和美鎮" "西鄉路"   
"新竹縣" "竹北市" "文興路"   
"桃園市" "中壢區" "中山路"   
end

In addition to `county' and `town', ,the new (third) variable `road' is often ended with 街/路/大道. However, the street names may contain "區/鄉" (the second/third observation) which may casue problem in obtaining proper `town' variable. I think that the `countytown' variable in #7 can be used to offer more correct classification. Do you have any suggestions? Thanks.

[River Huang]

Dear Andrew, Thanks for this useful suggestion (So, do you recognize Chinese?) There are two more (in blue).

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 city
"臺北市"
"台北市"
"臺中市"
"台中市"
"基隆市"
"臺南市"
"台南市"
"高雄市"
"新北市"
"宜蘭縣"
"桃園市"
"嘉義市"
"新竹縣"
"苗栗縣"
"南投縣"
"彰化縣"
"新竹市"
"雲林縣"
"嘉義縣"
"屏東縣"
"花蓮縣"
"臺東縣"
"台東縣"
"金門縣"
"澎湖縣"
"連江縣"
end

[Andrew Musau]

May I know the idea of

" " + t_addr2 + " "

What do empty spaces and + signs mean? Thanks.

Adding a space at the beginning and end is unnecessary here, but I do so if I need to modify the command to exclude some characters that may delimit the words to be matched. For example, consider the following where I want to match the word "boroughs". It is delimited by a colon and appears at the beginning of the string. Without a leading space, my regular expression will not match it, as below:

di regexm("boroughs: Manhattan, Brooklyn, Queens", "[' - ](boroughs|streets|lanes)['!?,\.: ]")
di regexm(" "+"boroughs: Manhattan, Brooklyn, Queens", "[' - ](boroughs|streets|lanes)['!?,\.: ]")

Res.:

. di regexm("boroughs: Manhattan, Brooklyn, Queens", "[' - ](boroughs|streets|lanes)['!?,\.: ]")
0

.
. di regexm(" "+"boroughs: Manhattan, Brooklyn, Queens", "[' - ](boroughs|streets|lanes)['!?,\.: ]")
1

So it is more a habit of mine to include leading and trailing spaces. I will respond to #10 and #11 in the course of the day once I have time to look at them.

[Andrew Musau]

I think that the `countytown' variable in #7 can be used to offer more correct classification. Do you have any suggestions?

Yes, that is possible after separating counties and towns in the countytown list. This is illustrated below.

So, do you recognize Chinese?

I cannot read Chinese.

* Example generated by -dataex-. For more info, type help dataex
clear
input str9 county
"臺北市"
"台北市"
"臺中市"
"台中市"
"基隆市"
"臺南市"
"台南市"
"高雄市"
"新北市"
"宜蘭縣"
"桃園市"
"嘉義市"
"新竹縣"
"苗栗縣"
"南投縣"
"彰化縣"
"新竹市"
"雲林縣"
"嘉義縣"
"屏東縣"
"花蓮縣"
"臺東縣"
"台東縣"
"金門縣"
"澎湖縣"
"連江縣"
end
levelsof county, local(counties) sep(|) clean

clear
input str144 t_addr2
"台北市市民大道三段2號5樓"                          
"台北市南港區園區街3之1號G棟8樓"                  
"508 彰化縣 和美鎮 西鄉路161巷2號"                  
"302 新竹縣竹北市文興路一段372號"                  
"320 桃園市 中壢區 桃園市中壢區中山路201號4樓"
end

gen county = ustrregexs(0) if ustrregexm(" " + t_addr2 + " ", "(`counties')")
frame create towns
frame change towns
* Example generated by -dataex-. For more info, type help dataex
clear
input str21 countytown
"南投縣中寮鄉"   
"南投縣仁愛鄉"   
"南投縣信義鄉"   
"南投縣南投市"   
"南投縣名間鄉"   
"南投縣國姓鄉"   
"南投縣埔里鎮"   
"南投縣水里鄉"   
"南投縣竹山鎮"   
"南投縣草屯鎮"   
"南投縣集集鎮"   
"南投縣魚池鄉"   
"南投縣鹿谷鄉"   
"嘉義市東區"      
"嘉義市西區"      
"嘉義縣中埔鄉"   
"嘉義縣六腳鄉"   
"嘉義縣大埔鄉"   
"嘉義縣大林鎮"   
"嘉義縣太保市"   
"嘉義縣布袋鎮"   
"嘉義縣新港鄉"   
"嘉義縣朴子市"   
"嘉義縣東石鄉"   
"嘉義縣梅山鄉"   
"嘉義縣民雄鄉"   
"嘉義縣水上鄉"   
"嘉義縣溪口鄉"   
"嘉義縣番路鄉"   
"嘉義縣竹崎鄉"   
"嘉義縣義竹鄉"   
"嘉義縣阿里山鄉"
"嘉義縣鹿草鄉"   
"基隆市七堵區"   
"基隆市中山區"   
"基隆市中正區"   
"基隆市仁愛區"   
"基隆市信義區"   
"基隆市安樂區"   
"基隆市暖暖區"   
"宜蘭縣三星鄉"   
"宜蘭縣五結鄉"   
"宜蘭縣冬山鄉"   
"宜蘭縣南澳鄉"   
"宜蘭縣員山鄉"   
"宜蘭縣壯圍鄉"   
"宜蘭縣大同鄉"   
"宜蘭縣宜蘭市"   
"宜蘭縣礁溪鄉"   
"宜蘭縣羅東鎮"   
"宜蘭縣蘇澳鎮"   
"宜蘭縣頭城鎮"   
"屏東縣三地門鄉"
"屏東縣九如鄉"   
"屏東縣佳冬鄉"   
"屏東縣來義鄉"   
"屏東縣內埔鄉"   
"屏東縣南州鄉"   
"屏東縣屏東市"   
"屏東縣崁頂鄉"   
"屏東縣恆春鎮"   
"屏東縣新園鄉"   
"屏東縣新埤鄉"   
"屏東縣春日鄉"   
"屏東縣東港鎮"   
"屏東縣枋寮鄉"   
"屏東縣枋山鄉"   
"屏東縣林邊鄉"   
"屏東縣泰武鄉"   
"屏東縣滿州鄉"   
"屏東縣潮州鎮"   
"屏東縣牡丹鄉"   
"屏東縣獅子鄉"   
"屏東縣琉球鄉"   
"屏東縣瑪家鄉"   
"屏東縣竹田鄉"   
"屏東縣萬丹鄉"   
"屏東縣萬巒鄉"   
"屏東縣車城鄉"   
"屏東縣里港鄉"   
"屏東縣長治鄉"   
"屏東縣霧臺鄉"   
"屏東縣高樹鄉"   
"屏東縣鹽埔鄉"   
"屏東縣麟洛鄉"   
"彰化縣二林鎮"   
"彰化縣二水鄉"   
"彰化縣伸港鄉"   
"彰化縣北斗鎮"   
"彰化縣和美鎮"   
"彰化縣員林市"   
"彰化縣埔心鄉"   
"彰化縣埔鹽鄉"   
"彰化縣埤頭鄉"   
"彰化縣大城鄉"   
"彰化縣大村鄉"   
"彰化縣彰化市"   
"彰化縣永靖鄉"   
"彰化縣溪州鄉"   
"彰化縣溪湖鎮"   
"彰化縣田中鎮"   
"彰化縣田尾鄉"   
"彰化縣社頭鄉"   
"彰化縣福興鄉"   
"彰化縣秀水鄉"   
"彰化縣竹塘鄉"   
"彰化縣線西鄉"   
"彰化縣芬園鄉"   
"彰化縣花壇鄉"   
"彰化縣芳苑鄉"   
"彰化縣鹿港鎮"   
"新北市三峽區"   
"新北市三芝區"   
"新北市三重區"   
"新北市中和區"   
"新北市五股區"   
"新北市八里區"   
"新北市土城區"   
"新北市坪林區"   
"新北市平溪區"   
"新北市新店區"   
"新北市新莊區"   
"新北市板橋區"   
"新北市林口區"   
"新北市樹林區"   
"新北市永和區"   
"新北市汐止區"   
"新北市泰山區"   
"新北市淡水區"   
"新北市深坑區"   
"新北市烏來區"   
"新北市瑞芳區"   
"新北市石碇區"   
"新北市石門區"   
"新北市萬里區"   
"新北市蘆洲區"   
"新北市貢寮區"   
"新北市金山區"   
"新北市雙溪區"   
"新北市鶯歌區"   
"新竹市北區"      
"新竹市東區"      
"新竹市香山區"   
"新竹縣五峰鄉"   
"新竹縣北埔鄉"   
"新竹縣寶山鄉"   
"新竹縣尖石鄉"   
"新竹縣峨眉鄉"   
"新竹縣新埔鎮"   
"新竹縣新豐鄉"   
"新竹縣橫山鄉"   
"新竹縣湖口鄉"   
"新竹縣竹北市"   
"新竹縣竹東鎮"   
"新竹縣芎林鄉"   
"新竹縣關西鎮"   
"桃園市中壢區"   
"桃園市八德區"   
"桃園市大園區"   
"桃園市大溪區"   
"桃園市平鎮區"   
"桃園市復興區"   
"桃園市新屋區"   
"桃園市桃園區"   
"桃園市楊梅區"   
"桃園市蘆竹區"   
"桃園市觀音區"   
"桃園市龍潭區"   
"桃園市龜山區"   
"澎湖縣七美鄉"   
"澎湖縣望安鄉"   
"澎湖縣湖西鄉"   
"澎湖縣白沙鄉"   
"澎湖縣西嶼鄉"   
"澎湖縣馬公市"   
"臺中市中區"      
"臺中市北區"      
"臺中市北屯區"   
"臺中市南區"      
"臺中市南屯區"   
"臺中市后里區"   
"臺中市和平區"   
"臺中市外埔區"   
"臺中市大安區"   
"臺中市大甲區"   
"臺中市大肚區"   
"臺中市大里區"   
"臺中市大雅區"   
"臺中市太平區"   
"臺中市新社區"   
"臺中市東勢區"   
"臺中市東區"      
"臺中市梧棲區"   
"臺中市沙鹿區"   
"臺中市清水區"   
"臺中市潭子區"   
"臺中市烏日區"   
"臺中市石岡區"   
"臺中市神岡區"   
"臺中市西區"      
"臺中市西屯區"   
"臺中市豐原區"   
"臺中市霧峰區"   
"臺中市龍井區"   
"臺北市中山區"   
"臺北市中正區"   
"臺北市信義區"   
"臺北市內湖區"   
"臺北市北投區"   
"臺北市南港區"   
"臺北市士林區"   
"臺北市大同區"   
"臺北市大安區"   
"臺北市文山區"   
"臺北市松山區"   
"臺北市萬華區"   
"臺南市七股區"   
"臺南市下營區"   
"臺南市中西區"   
"臺南市仁德區"   
"臺南市佳里區"   
"臺南市六甲區"   
"臺南市北區"      
"臺南市北門區"   
"臺南市南化區"   
"臺南市南區"      
"臺南市善化區"   
"臺南市大內區"   
"臺南市學甲區"   
"臺南市安南區"   
"臺南市安定區"   
"臺南市安平區"   
"臺南市官田區"   
"臺南市將軍區"   
"臺南市山上區"   
"臺南市左鎮區"   
"臺南市後壁區"   
"臺南市新化區"   
"臺南市新市區"   
"臺南市新營區"   
"臺南市東區"      
"臺南市東山區"   
"臺南市柳營區"   
"臺南市楠西區"   
"臺南市歸仁區"   
"臺南市永康區"   
"臺南市玉井區"   
"臺南市白河區"   
"臺南市西港區"   
"臺南市關廟區"   
"臺南市鹽水區"   
"臺南市麻豆區"   
"臺南市龍崎區"   
"臺東縣卑南鄉"   
"臺東縣大武鄉"   
"臺東縣太麻里鄉"
"臺東縣延平鄉"   
"臺東縣成功鎮"   
"臺東縣東河鄉"   
"臺東縣池上鄉"   
"臺東縣海端鄉"   
"臺東縣綠島鄉"   
"臺東縣臺東市"   
"臺東縣蘭嶼鄉"   
"臺東縣達仁鄉"   
"臺東縣金峰鄉"   
"臺東縣長濱鄉"   
"臺東縣關山鎮"   
"臺東縣鹿野鄉"   
"花蓮縣光復鄉"   
"花蓮縣卓溪鄉"   
"花蓮縣吉安鄉"   
"花蓮縣壽豐鄉"   
"花蓮縣富里鄉"   
"花蓮縣新城鄉"   
"花蓮縣玉里鎮"   
"花蓮縣瑞穗鄉"   
"花蓮縣秀林鄉"   
"花蓮縣花蓮市"   
"花蓮縣萬榮鄉"   
"花蓮縣豐濱鄉"   
"花蓮縣鳳林鎮"   
"苗栗縣三灣鄉"   
"苗栗縣三義鄉"   
"苗栗縣公館鄉"   
"苗栗縣卓蘭鎮"   
"苗栗縣南庄鄉"   
"苗栗縣大湖鄉"   
"苗栗縣後龍鎮"   
"苗栗縣泰安鄉"   
"苗栗縣獅潭鄉"   
"苗栗縣竹南鎮"   
"苗栗縣苑裡鎮"   
"苗栗縣苗栗市"   
"苗栗縣西湖鄉"   
"苗栗縣通霄鎮"   
"苗栗縣造橋鄉"   
"苗栗縣銅鑼鄉"   
"苗栗縣頭份市"   
"苗栗縣頭屋鄉"   
"連江縣北竿鄉"   
"連江縣南竿鄉"   
"連江縣東引鄉"   
"連江縣莒光鄉"   
"金門縣烈嶼鄉"   
"金門縣烏坵鄉"   
"金門縣金城鎮"   
"金門縣金寧鄉"   
"金門縣金沙鎮"   
"金門縣金湖鎮"   
"雲林縣二崙鄉"   
"雲林縣元長鄉"   
"雲林縣北港鎮"   
"雲林縣口湖鄉"   
"雲林縣古坑鄉"   
"雲林縣四湖鄉"   
"雲林縣土庫鎮"   
"雲林縣大埤鄉"   
"雲林縣崙背鄉"   
"雲林縣斗六市"   
"雲林縣斗南鎮"   
"雲林縣東勢鄉"   
"雲林縣林內鄉"   
"雲林縣水林鄉"   
"雲林縣臺西鄉"   
"雲林縣莿桐鄉"   
"雲林縣虎尾鎮"   
"雲林縣褒忠鄉"   
"雲林縣西螺鎮"   
"雲林縣麥寮鄉"   
"高雄市三民區"   
"高雄市仁武區"   
"高雄市內門區"   
"高雄市六龜區"   
"高雄市前金區"   
"高雄市前鎮區"   
"高雄市南沙群島"
"高雄市大寮區"   
"高雄市大樹區"   
"高雄市大社區"   
"高雄市小港區"   
"高雄市岡山區"   
"高雄市左營區"   
"高雄市彌陀區"   
"高雄市新興區"   
"高雄市旗山區"   
"高雄市旗津區"   
"高雄市杉林區"   
"高雄市東沙群島"
"高雄市林園區"   
"高雄市桃源區"   
"高雄市梓官區"   
"高雄市楠梓區"   
"高雄市橋頭區"   
"高雄市永安區"   
"高雄市湖內區"   
"高雄市燕巢區"   
"高雄市田寮區"   
"高雄市甲仙區"   
"高雄市美濃區"   
"高雄市苓雅區"   
"高雄市茂林區"   
"高雄市茄萣區"   
"高雄市路竹區"   
"高雄市那瑪夏區"
"高雄市阿蓮區"   
"高雄市鳥松區"   
"高雄市鳳山區"   
"高雄市鹽埕區"   
"高雄市鼓山區"   
end
gen county = ustrregexra(countytown,"(.*縣|.*市)?(.*)?", "$1")
gen town = ustrregexra(countytown,county, "")
levelsof town, local(towns) sep(|) clean
frame change default
frame drop towns
gen town = ustrregexs(0) if ustrregexm(t_addr2, "(`towns')")
gen road= ustrregexra(ustrregexra(ustrregexra(t_addr2, county, "", 1), town, "", 1), "^([0-9]*)(.*街|.*路|.*大道)?(.*)?", "$2")

Res.:

. l county town road

     +-----------------------------+
     | county     town        road |
     |-----------------------------|
  1. | 台北市             市民大道 |
  2. | 台北市   南港區      園區街 |
  3. | 彰化縣   和美鎮      西鄉路 |
  4. | 新竹縣   竹北市      文興路 |
  5. | 桃園市   中壢區      中山路 |
     +-----------------------------+

[River Huang]

Dear Andrew, Many thanks for these suggestion. I learn a lot from your insightful illustration.

[River Huang]

Dear Andrew, There is a classicifcation error in the suggested code:

* Example generated by -dataex-. For more info, type help dataex
clear
input str21 countytown
"南投縣中寮鄉"   
"南投縣仁愛鄉"   
"南投縣信義鄉"   
"南投縣南投市"   
"南投縣名間鄉"   
"南投縣國姓鄉"   
"南投縣埔里鎮"   
"南投縣水里鄉"   
"南投縣竹山鎮"   
"南投縣草屯鎮"   
"南投縣集集鎮"   
"南投縣魚池鄉"   
"南投縣鹿谷鄉"   
"嘉義市東區"      
"嘉義市西區"      
"嘉義縣中埔鄉"   
"嘉義縣六腳鄉"   
"嘉義縣大埔鄉"   
"嘉義縣大林鎮"   
"嘉義縣太保市"   
"嘉義縣布袋鎮"   
"嘉義縣新港鄉"   
"嘉義縣朴子市"   
"嘉義縣東石鄉"   
"嘉義縣梅山鄉"   
"嘉義縣民雄鄉"   
"嘉義縣水上鄉"   
"嘉義縣溪口鄉"   
"嘉義縣番路鄉"   
"嘉義縣竹崎鄉"   
"嘉義縣義竹鄉"   
"嘉義縣阿里山鄉"
"嘉義縣鹿草鄉"   
"基隆市七堵區"   
"基隆市中山區"   
"基隆市中正區"   
"基隆市仁愛區"   
"基隆市信義區"   
"基隆市安樂區"   
"基隆市暖暖區"   
"宜蘭縣三星鄉"   
"宜蘭縣五結鄉"   
"宜蘭縣冬山鄉"   
"宜蘭縣南澳鄉"   
"宜蘭縣員山鄉"   
"宜蘭縣壯圍鄉"   
"宜蘭縣大同鄉"   
"宜蘭縣宜蘭市"   
"宜蘭縣礁溪鄉"   
"宜蘭縣羅東鎮"   
"宜蘭縣蘇澳鎮"   
"宜蘭縣頭城鎮"   
"屏東縣三地門鄉"
"屏東縣九如鄉"   
"屏東縣佳冬鄉"   
"屏東縣來義鄉"   
"屏東縣內埔鄉"   
"屏東縣南州鄉"   
"屏東縣屏東市"   
"屏東縣崁頂鄉"   
"屏東縣恆春鎮"   
"屏東縣新園鄉"   
"屏東縣新埤鄉"   
"屏東縣春日鄉"   
"屏東縣東港鎮"   
"屏東縣枋寮鄉"   
"屏東縣枋山鄉"   
"屏東縣林邊鄉"   
"屏東縣泰武鄉"   
"屏東縣滿州鄉"   
"屏東縣潮州鎮"   
"屏東縣牡丹鄉"   
"屏東縣獅子鄉"   
"屏東縣琉球鄉"   
"屏東縣瑪家鄉"   
"屏東縣竹田鄉"   
"屏東縣萬丹鄉"   
"屏東縣萬巒鄉"   
"屏東縣車城鄉"   
"屏東縣里港鄉"   
"屏東縣長治鄉"   
"屏東縣霧臺鄉"   
"屏東縣高樹鄉"   
"屏東縣鹽埔鄉"   
"屏東縣麟洛鄉"   
"彰化縣二林鎮"   
"彰化縣二水鄉"   
"彰化縣伸港鄉"   
"彰化縣北斗鎮"   
"彰化縣和美鎮"   
"彰化縣員林市"   
"彰化縣埔心鄉"   
"彰化縣埔鹽鄉"   
"彰化縣埤頭鄉"   
"彰化縣大城鄉"   
"彰化縣大村鄉"   
"彰化縣彰化市"   
"彰化縣永靖鄉"   
"彰化縣溪州鄉"   
"彰化縣溪湖鎮"   
"彰化縣田中鎮"   
"彰化縣田尾鄉"   
"彰化縣社頭鄉"   
"彰化縣福興鄉"   
"彰化縣秀水鄉"   
"彰化縣竹塘鄉"   
"彰化縣線西鄉"   
"彰化縣芬園鄉"   
"彰化縣花壇鄉"   
"彰化縣芳苑鄉"   
"彰化縣鹿港鎮"   
"新北市三峽區"   
"新北市三芝區"   
"新北市三重區"   
"新北市中和區"   
"新北市五股區"   
"新北市八里區"   
"新北市土城區"   
"新北市坪林區"   
"新北市平溪區"   
"新北市新店區"   
"新北市新莊區"   
"新北市板橋區"   
"新北市林口區"   
"新北市樹林區"   
"新北市永和區"   
"新北市汐止區"   
"新北市泰山區"   
"新北市淡水區"   
"新北市深坑區"   
"新北市烏來區"   
"新北市瑞芳區"   
"新北市石碇區"   
"新北市石門區"   
"新北市萬里區"   
"新北市蘆洲區"   
"新北市貢寮區"   
"新北市金山區"   
"新北市雙溪區"   
"新北市鶯歌區"   
"新竹市北區"      
"新竹市東區"      
"新竹市香山區"   
"新竹縣五峰鄉"   
"新竹縣北埔鄉"   
"新竹縣寶山鄉"   
"新竹縣尖石鄉"   
"新竹縣峨眉鄉"   
"新竹縣新埔鎮"   
"新竹縣新豐鄉"   
"新竹縣橫山鄉"   
"新竹縣湖口鄉"   
"新竹縣竹北市"   
"新竹縣竹東鎮"   
"新竹縣芎林鄉"   
"新竹縣關西鎮"   
"桃園市中壢區"   
"桃園市八德區"   
"桃園市大園區"   
"桃園市大溪區"   
"桃園市平鎮區"   
"桃園市復興區"   
"桃園市新屋區"   
"桃園市桃園區"   
"桃園市楊梅區"   
"桃園市蘆竹區"   
"桃園市觀音區"   
"桃園市龍潭區"   
"桃園市龜山區"   
"澎湖縣七美鄉"   
"澎湖縣望安鄉"   
"澎湖縣湖西鄉"   
"澎湖縣白沙鄉"   
"澎湖縣西嶼鄉"   
"澎湖縣馬公市"   
"臺中市中區"      
"臺中市北區"      
"臺中市北屯區"   
"臺中市南區"      
"臺中市南屯區"   
"臺中市后里區"   
"臺中市和平區"   
"臺中市外埔區"   
"臺中市大安區"   
"臺中市大甲區"   
"臺中市大肚區"   
"臺中市大里區"   
"臺中市大雅區"   
"臺中市太平區"   
"臺中市新社區"   
"臺中市東勢區"   
"臺中市東區"      
"臺中市梧棲區"   
"臺中市沙鹿區"   
"臺中市清水區"   
"臺中市潭子區"   
"臺中市烏日區"   
"臺中市石岡區"   
"臺中市神岡區"   
"臺中市西區"      
"臺中市西屯區"   
"臺中市豐原區"   
"臺中市霧峰區"   
"臺中市龍井區"   
"臺北市中山區"   
"臺北市中正區"   
"臺北市信義區"   
"臺北市內湖區"   
"臺北市北投區"   
"臺北市南港區"   
"臺北市士林區"   
"臺北市大同區"   
"臺北市大安區"   
"臺北市文山區"   
"臺北市松山區"   
"臺北市萬華區"   
"臺南市七股區"   
"臺南市下營區"   
"臺南市中西區"   
"臺南市仁德區"   
"臺南市佳里區"   
"臺南市六甲區"   
"臺南市北區"      
"臺南市北門區"   
"臺南市南化區"   
"臺南市南區"      
"臺南市善化區"   
"臺南市大內區"   
"臺南市學甲區"   
"臺南市安南區"   
"臺南市安定區"   
"臺南市安平區"   
"臺南市官田區"   
"臺南市將軍區"   
"臺南市山上區"   
"臺南市左鎮區"   
"臺南市後壁區"   
"臺南市新化區"   
"臺南市新市區"   
"臺南市新營區"   
"臺南市東區"      
"臺南市東山區"   
"臺南市柳營區"   
"臺南市楠西區"   
"臺南市歸仁區"   
"臺南市永康區"   
"臺南市玉井區"   
"臺南市白河區"   
"臺南市西港區"   
"臺南市關廟區"   
"臺南市鹽水區"   
"臺南市麻豆區"   
"臺南市龍崎區"   
"臺東縣卑南鄉"   
"臺東縣大武鄉"   
"臺東縣太麻里鄉"
"臺東縣延平鄉"   
"臺東縣成功鎮"   
"臺東縣東河鄉"   
"臺東縣池上鄉"   
"臺東縣海端鄉"   
"臺東縣綠島鄉"   
"臺東縣臺東市"   
"臺東縣蘭嶼鄉"   
"臺東縣達仁鄉"   
"臺東縣金峰鄉"   
"臺東縣長濱鄉"   
"臺東縣關山鎮"   
"臺東縣鹿野鄉"   
"花蓮縣光復鄉"   
"花蓮縣卓溪鄉"   
"花蓮縣吉安鄉"   
"花蓮縣壽豐鄉"   
"花蓮縣富里鄉"   
"花蓮縣新城鄉"   
"花蓮縣玉里鎮"   
"花蓮縣瑞穗鄉"   
"花蓮縣秀林鄉"   
"花蓮縣花蓮市"   
"花蓮縣萬榮鄉"   
"花蓮縣豐濱鄉"   
"花蓮縣鳳林鎮"   
"苗栗縣三灣鄉"   
"苗栗縣三義鄉"   
"苗栗縣公館鄉"   
"苗栗縣卓蘭鎮"   
"苗栗縣南庄鄉"   
"苗栗縣大湖鄉"   
"苗栗縣後龍鎮"   
"苗栗縣泰安鄉"   
"苗栗縣獅潭鄉"   
"苗栗縣竹南鎮"   
"苗栗縣苑裡鎮"   
"苗栗縣苗栗市"   
"苗栗縣西湖鄉"   
"苗栗縣通霄鎮"   
"苗栗縣造橋鄉"   
"苗栗縣銅鑼鄉"   
"苗栗縣頭份市"   
"苗栗縣頭屋鄉"   
"連江縣北竿鄉"   
"連江縣南竿鄉"   
"連江縣東引鄉"   
"連江縣莒光鄉"   
"金門縣烈嶼鄉"   
"金門縣烏坵鄉"   
"金門縣金城鎮"   
"金門縣金寧鄉"   
"金門縣金沙鎮"   
"金門縣金湖鎮"   
"雲林縣二崙鄉"   
"雲林縣元長鄉"   
"雲林縣北港鎮"   
"雲林縣口湖鄉"   
"雲林縣古坑鄉"   
"雲林縣四湖鄉"   
"雲林縣土庫鎮"   
"雲林縣大埤鄉"   
"雲林縣崙背鄉"   
"雲林縣斗六市"   
"雲林縣斗南鎮"   
"雲林縣東勢鄉"   
"雲林縣林內鄉"   
"雲林縣水林鄉"   
"雲林縣臺西鄉"   
"雲林縣莿桐鄉"   
"雲林縣虎尾鎮"   
"雲林縣褒忠鄉"   
"雲林縣西螺鎮"   
"雲林縣麥寮鄉"   
"高雄市三民區"   
"高雄市仁武區"   
"高雄市內門區"   
"高雄市六龜區"   
"高雄市前金區"   
"高雄市前鎮區"   
"高雄市南沙群島"
"高雄市大寮區"   
"高雄市大樹區"   
"高雄市大社區"   
"高雄市小港區"   
"高雄市岡山區"   
"高雄市左營區"   
"高雄市彌陀區"   
"高雄市新興區"   
"高雄市旗山區"   
"高雄市旗津區"   
"高雄市杉林區"   
"高雄市東沙群島"
"高雄市林園區"   
"高雄市桃源區"   
"高雄市梓官區"   
"高雄市楠梓區"   
"高雄市橋頭區"   
"高雄市永安區"   
"高雄市湖內區"   
"高雄市燕巢區"   
"高雄市田寮區"   
"高雄市甲仙區"   
"高雄市美濃區"   
"高雄市苓雅區"   
"高雄市茂林區"   
"高雄市茄萣區"   
"高雄市路竹區"   
"高雄市那瑪夏區"
"高雄市阿蓮區"   
"高雄市鳥松區"   
"高雄市鳳山區"   
"高雄市鹽埕區"   
"高雄市鼓山區"   
end

gen county = ustrregexra(countytown,"(.*縣|.*市)?(.*)?", "$1")
gen town = ustrregexra(countytown,county, "")

list in 238/240

. list in 238/240 
     +------------------------------------+
     |   countytown       county     town |
     |------------------------------------|
238. | 臺南市新化區       臺南市   新化區 |
239. | 臺南市新市區   臺南市新市       區 |
240. | 臺南市新營區       臺南市   新營區 |
     +------------------------------------+

For the 239th observation, it should be

臺南市   新市區

。Thus, I guess we should use your prior suggestion

 
 gen county = ustrregexs(0) if ustrregexm(" " + t_addr2 + " ", "(`counties')")

to extract cities/counties (instead of gen county = ustrregexra(countytown,"(.*縣|.*市)?(.*)?", "$1")). Any comments?