Let's compile a ist of all geographic/geopolitical entities whose names contain at least 3 letters A and no other vowels.
Include states (like Alabama), rivers (Angara), mountains (Ararat), cities (Larnaca) etc.
Your entries must appear in reliable dictionary/atlas/database.
(In reply to
World cities and U.S. states -- same idea -- from Wikipedia pages by Charlie)
Wikipedia listed a few countries differently so their cities were excluded. Also, in some other countries, such as Brazil, states were and are included as well as cities. (I realized for example that Mexico was missing when I didn't see Mazatlan).
Kandahar Afghanistan
Jalalabad Afghanistan
Annaba Algeria
Batna Algeria
Béjaïa Algeria
Béchar Algeria
Médéa Algeria
Saïda Algeria
La Plata Argentina
Salta Argentina
BahÃa Blanca Argentina
Paraná Argentina
Ganja Azerbaijan
Manama Bahrain
Dhaka Bangladesh
Nawabganj Bangladesh
Pabna Bangladesh
La Paz Bolivia
Pará Brazil
Pará Brazil
Pará Brazil
Paraná Brazil
Araras Brazil
Bagé Brazil
Barra Mansa Brazil
Pará Brazil
ParaÃba Brazil
Paraná Brazil
Castanhal Brazil
Pará Brazil
Paraná Brazil
Paraná Brazil
Paraná Brazil
Franca Brazil
Paraná Brazil
Gravataà Brazil
Jaú Brazil
ParaÃba Brazil
Paraná Brazil
Macaé Brazil
Macapá Brazil
Amapá Brazil
Magé Brazil
Marabá Brazil
Pará Brazil
Maracanaú Brazil
Paraná Brazil
Natal Brazil
Palmas Brazil
Paraná Brazil
ParnaÃba Brazil
Paraná Brazil
Paraná Brazil
Sabará Brazil
ParaÃba Brazil
Santarém Brazil
Pará Brazil
Paraná Brazil
Paraná Brazil
Varna Bulgaria
Battambang Cambodia
Laval Canada
Markham Canada
Ajax Canada
Sarh Chad
Calama Chile
Talca Chile
Ma'anshan
Handan
Langfang
Tangshan
Anda
Changsha
Nanchang
Daan
Kashgar
Santa Marta Colombia
Kananga Democratic Republic of the Congo
Mbandaka Democratic Republic of the Congo
Baraka Democratic Republic of the Congo
Havana Cuba
Matanzas Cuba
Santa Clara Cuba
Larnaca Cyprus
Banà Dominican Republic
Machala Ecuador
Manta Ecuador
Manabà Ecuador
Manabà Ecuador
Aswan Egypt
Banha Egypt
Kafr Dawar Egypt
Tanta Egypt
Santa Ana El Salvador
Bata Equatorial Guinea
Asmara Eritrea
Amhara Ethiopia
Adama Ethiopia
Hawassa Ethiopia
SNNPR Ethiopia
Amhara Ethiopia
Amhara Ethiopia
SNNPR Ethiopia
SNNPR Ethiopia
SNNPR Ethiopia
Harar Ethiopia
Harar Ethiopia
SNNPR Ethiopia
Amhara Ethiopia
Amhara Ethiopia
Vantaa Finland
Darmstadt Germany
Fürth Germany
Hamm Germany
Accra Ghana
Patras Greece
Kankan Guinea
Pécs Hungary
Agartala India
Agra India
Allahabad India
Alwar India
Ambala India
Anand India
Arrah India
Baranagar India
Barddhaman India
Batala India
Bhatpara India
Bhavnagar India
Chandan Nagar India
Chhapra India
Dabgram India
Darbhanga India
Dhanbad India
Ganganagar India
Habra India
Hassan India
Hathras India
Jalandhar India
Jalna India
Jamnagar India
Kanchrapara India
Kanhangad India
Karjat India
Karnal India
Khandwa India
Madras India
Palakkad India
Patan India
Patna India
Ranaghat India
Ratlam India
Sagar India
Sambhal India
Satna India
Vatakara India
Valsad India
Wadhwan India
Warangal India
Wardha India
Batam Indonesia
Jakarta Indonesia
Makassar Indonesia
Malang Indonesia
Padang Indonesia
Tarakan Indonesia
Mashhad Iran
Karaj Iran
Fars Iran
Ahvaz Iran
Rasht Iran
Arak Iran
Hamadan Iran
Bandar Abbas Iran
Qazv?n Iran
Zanjan Iran
Zanjan Iran
Sanandaj Iran
Malard Iran
Kashan Iran
Mazandaran Iran
Najafabad Iran
Mazandaran Iran
Mazandaran Iran
Abadan Iran
Pakdasht Iran
Mazandaran Iran
Gharchak Iran
Hamadan Iran
Mahshahr Iran
Rafsanjan Iran
Mahabad Iran
Marvdasht Iran
Fars Iran
Marand Iran
Fars Iran
Kamal Shahr Iran
Nazarabad Iran
Bam Iran
Fasa Iran
Fars Iran
Baghdad Iraq
Basra Iraq
Halabja Iraq
H?t Iraq
Najaf Iraq
Samarra Iraq
Ramat Gan Israel
Parma Italy
Anj? Japan
Asaka Japan
Handa Japan
Kanazawa Japan
Naha Japan
Nara Japan
Saga Japan
Sakata Japan
Sanda Japan
Tama Japan
Zama Japan
Zarqa Jordan
Ar-Ramtha Jordan
Aqaba Jordan
Astana Kazakhstan
Karaganda Kazakhstan
Taraz Kazakhstan
Kajang Malaysia
Klang Malaysia
Sandakan Malaysia
Shah Alam Malaysia
Malé Maldives
Cancún Mexico
La Paz Mexico
Mazatlán Mexico
Salamanca Mexico
Xalapa Mexico
Casablanca Morocco
Rabat Morocco
Salé Morocco
Nacala Mozambique
Dharan Nepal
Zaanstad Netherlands
Granada Nicaragua
Matagalpa Nicaragua
Awka Nigeria
Calabar Nigeria
Barka Oman
Saham Oman
Salalah Oman
Bahawalnagar Pakistan
Bhalwal Pakistan
Daska Pakistan
Jaranwala Pakistan
Jhang Pakistan
Larkana Pakistan
Mardan Pakistan
Nawabshah Pakistan
Pakpattan Pakistan
Rafah Palestine
Lambaré Paraguay
Cajamarca Peru
Tacna Peru
Talara Peru
Gda?sk Poland
Kraków Poland
Tarnów Poland
Warsaw Poland
Braga Portugal
Angarsk Russian Federation
Arzamas Russian Federation
Astrakhan Russian Federation
Bratsk Russian Federation
Kazan Russian Federation
Makhachkala Russian Federation
Salavat Russian Federation
Samara Russian Federation
Saransk Russian Federation
Abha Saudi Arabia
Ansan South Korea
Hanam South Korea
Malakal South Sudan
Granada Spain
Jaén Spain
Las Palmas Spain
Mataró Spain
Málaga Spain
Salamanca Spain
Jaffna Sri Lanka
Kassala Sudan
Malmö Sweden
Raqqa Syria
Hama Syria
Mwanza Tanzania
Tanga Tanzania
Gabès Tunisia
Sfax Tunisia
Adapazar? Turkey
Ankara Turkey
Batman Turkey
Kahramanmara? Turkey
Karaman Turkey
Van Turkey
Ashgabat Turkmenistan
Kampala Uganda
Sharjah United Arab Emirates
Ajman United Arab Emirates
Walsall United Kingdom
Dallas United States
Atlanta United States
Kansas United States
Tampa United States
Santa Ana United States
Alaska United States
Garland United States
Alabama United States
Alabama United States
Arkansas United States
Alabama United States
Alabama United States
Kansas United States
Kansas United States
Savannah United States
Kansas United States
Kansas United States
Santa Clara United States
Arvada United States
Carlsbad United States
Namangan Uzbekistan
Namangan Uzbekistan
Karakalpakstan Uzbekistan
Samarkand Uzbekistan
Samarqand Uzbekistan
Karakalpakstan Uzbekistan
Caracas Venezuela
C?m Ph? Vietnam
C?n Th? Vietnam
Nam ??nh Vietnam
Nha Trang Vietnam
Sana'a Yemen
Sana'a Yemen
Dhamar Yemen
Dhamar Yemen
Kasama Zambia
The blanks in the country column seem to be for China.
Revised line of code is
ElseIf Left(l, 5) = "<td><" Or Left(l, 5) = "ps://" Or Left(l, 5) = "<li><" Then
|
|
Posted by Charlie
on 2019-04-17 20:50:11 |
Some cities and states were missed
