We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Exporting report in CSV adds extra space to field

Accepted answer
25
Views
2
Comments
edited Jul 26, 2017 9:54AM in General Transactional Reporting (OTBI) 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!