Exporting report in CSV adds extra space to field
Summary
CSV report adds a space to a field, which doesnt happen when report is exported via Excel.Content
Hi,
I have one report which is automatically scheduled to be sent in CSV format every week. However, this report is for some reason exporting one location with an extra space. All our locations look like:
|
US - CHARLOTTE |
US - CHICAGO |
US - DALLAS |
US - LA |
US - MIAMI |
US - NEW JERSEY |
However, we have one value that comes out like 'US - New York' (with an extra space either side of the '-'). This is weird as when I export the file in excel it is fine, and in the system it is fine and in the correct format as every other location.
Tagged:
0