This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The key is not the parsing, but how to identify which data point belongs in each column. Think of teaching a person how to do this if that person had no context of city or country. Absent a key (i.e. - Text Box with list of Countries) or training (machine learning), it becomes almost impossible for that person to be completely correct. Even then there is a possibility for error where a city is named after a country (Singapore, MI). Are there any other identifiers in the data? Sample data may help.