CiviCRM Community Forums (archive)

Hi,

I'm trying to import a set of contacts. I have a few invalid field errors, but the most irritating to deal with is a list of countries. In my CSV file it's a comma-separated list, which for the most part looks like it will import just fine. However, if I have a country whose name contains a comma, such as "Palestinian Territory, Occupied" (from what I believe is the default set of countries in CiviCRM) that comma-separated list obviously no longer works (e.g. it could read as "Cuba, Palestinian Territory, Occupied, Tuvalu").

Is there a known workaround for this, or have I failed to see a simple solution?

Thanks in advance if anyone can help!

I should have mentioned that I've tried encapsulating the terms that have commas in quotation marks, to no avail. Thanks for the suggestion though.

For example, in the import errors for a field whose contents are

Malawi, "Tanzania, United Republic of", Zambia, Cambodia, Lebanon, "Palestinian Territory, Occupied"

I get

Malawi, Tanzania

I've had a few situations where people have told me they can't export due to commas - but on investigation it turns out they've use quotations marks  (often around nick names) & that it actually the point of failure