leading zeros getting removed in csv export(OBIEE)

2879152

I have one primary id which has data like 001,002,003 but when i export that to CSV i'm getting 1,2,3.

But i need the data should be like 001,002,003 only even after export.

Any suggestion would be helpful.

Gianni Ceresa

What's the type of that column?

Sherry George

Also did you open the csv in MS excel? If so, try opening in a different editor (wordpad?np++ etc..)  and see if they are still missing the 0's.

[Deleted User]

+1 to Gianni - what's the data type?

Because 0001 is a string whereas 1 is a number.

2879152

data type is varchar2.

2879152

Yes in CSV Excel format. If i open in Word format i'm getting correctly but user will open in CSV.

[Deleted User]

Ok so basically you are exporting a CSV that is fundamentally correct and then you open it in Excel and Excel being stupid Excel shows 1,2,3.

Next time look into the actual CSV file and describe your issue better because it's a non-issue...well an Excel issue that is ;-)

Sherry George

Christian beat me to it. The issue is with MS Excel and not OBIEE. If they must use Excel, they can import the data from the .csv file using the EXCEL Data tab and could use 'text' as data type for the particular field with the issue.

https://support.office.com/en-us/article/Text-Import-Wizard-c5b02af6-fda1-4440-899f-f78bafe41857?ui=en-US&rs=en-US&ad=US

2879152

Do you know any conversion in OBIEE to get data like 001,002 after exporting in csv?

2879152

the user wants to like 001 when they export. (With out any manual changes)

Sherry George

Export to Excel instead of csv.