Hi,

All of your examples have the same format such that a simple TextToColumns usiing the comma as a delimiter will parse the strings putting the city in the 3rd column. Only you can say whether all the data is consistent. You could easily check by using a helper column to count the number of commas in each string.