Split address based on Country and different factor

[zmaniar]

Hello, I have list of 15000 names which I want to split in Column 1, Column 2, City, State, Zip, Country.

The problem is they don't have any particular order.

1. They are of different countries
2. Some has Zip code, some don't
3. Some has city, Some don't
4. Some has university department (multiple), so just have name of the universities.

Any idea on how to solve it?

Harper, L.R., Department of Biological and Marine Sciences, University of Hull, Hull, HU6 7RX, United Kingdom, Illinois Natural History Survey, Prairie Research Institute, University of Illinois at Urbana-Champaign, Champaign, IL, United States

Schill, W.B., US Geological Survey, National Fish Health Research Laboratory, Leetown, WV, United States

Alsos, I.G., Tromsø Museum, University of Tromsø –The Arctic University of Norway, Tromsø, Norway

Klymus, K.E., Columbia Environmental Research Center, U.S. Geological Survey, Columbia, MO 65201, United States

Ficetola, G.F., Laboratoire d'Ecologie Alpine (LECA), Université Grenoble Alpes Savoie, Grenoble, F-38000, France

Carraro, L., Department of Evolutionary Biology and Environmental Studies, University of Zurich, Winterthurerstr. 190, Zürich, CH-8057, Switzerland, Department of Aquatic Ecology, Eawag, Swiss Federal Institute of Aquatic Science and Technology, Überlandstrasse 133, Dübendorf, CH-8600, Switzerland

Bailet, B., Swedish University of Agricultural Sciences, Department of Aquatic Sciences and Assessment, PO Box 7050, Uppsala, SE – 750 07, Sweden

Vančurová, L., Charles University, Faculty of Science, Department of Botany, Benátská 2, Prague 2, 128 01, Czech Republic

Li, X., State Key Laboratory of Environmental Criteria and Risk Assessment, Chinese Research Academy of Environmental Sciences, Beijing, 100012, China

Fan, J., State Key Laboratory of Environmental Criteria and Risk Assessment, Chinese Research Academy of Environmental Sciences, Beijing, 100012, China

Cao, X., Center for Water and Ecology, State Key Joint Laboratory of Environment Simulation and Pollution Control, School of Environment, Tsinghua University, Beijing, 100084, China

Redekar, N.R., Department of Crop and Soil Science, Oregon State University, Corvallis, OR 97331, United States

Schenekar, T., Institute of Biology, University of Graz, Graz, Austria

 

[OaklandJim]

It seems to me that there is no way to dissect each entry as there is no pattern to try to discern.