Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Exporting report in CSV adds extra space to field — Cloud Customer Connect
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!