Page MenuHomePhabricator

Data Exported from Civi contains spaces
Open, Needs TriagePublic2 Story Points


Data exported from Civi can sometimes contain spaces that make it difficult to use in a clean and efficient manner.

For example, email lists exported from Civi can contain spaces around some of the emails. This makes it difficult for the email team to upload this list into IBM.

Goal would be to make it easier to export and parse data without extra spaces (fwiw, text to columns delimiting on space did not fix the problem, after multiple attempts).

Event Timeline

NNichols created this task.Tue, Aug 27, 2:36 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptTue, Aug 27, 2:36 PM

@NNichols I originally assumed that the 'some' of the emails would be ones with spaces in them in Civi - but I only find about 1000 emails in our db that start or end in space so that seems unlikely - can you give me steps to replicate?

@Eileenmcnaughton I don't know if these spaces exist around the email in civi. We are running into this issue when we export emails. The CSV that we get has spaces at the end of the emails in the cell.

@NNichols I removed spaces from the emails in civi - 1480 emails affected - but I don't think that's it.

I can't replicate it though...