Oracle Transactional Business Intelligence

Products Banner

Exporting report in CSV adds extra space to field

Received Response
85
Views
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.

 

Has anyone experienced this when exporting in CSV and has a fix?

 

Please inform me, appreciate all help.

Answers

  • OBIEE always hides consecutive spaces between any characters and displays only one space character, if your actual data is 'US  -  New York' with two consecutive  spaces before and after the ‘-‘ character, it will display the value as 'US - New York' with only one space. But if you export the same report output as CSV format, it will export the actual data with all the spacing characters.

    The consecutive  space characters are present in your actual data itself. Either you can correct your actual data or you can use the below formula in OBIEE report to replace  two consecutive  space characters with one space character.

    Expression :  Replace(column_name, '  ', ' ')

    Pls let us know if this resolves your issue.

  • 3487945
    3487945 ✭✭✭

    Thanks, issue resolved.