Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
leading zeros getting removed in csv export(OBIEE)
Answers
-
the amount of data we have cant be exported in excel format.
0 -
Why conversion? Open the CSV file with a proper editor. It will LITERALLY contain 0001!
0 -
Ok obvious and obligatory question: Why are you using OBIEE as a data pump?
0 -
I'm opening with Microsoft excel and its not showing like 001.
0 -
Agree with Christian here, you might want to revisit what you are doing here. Anyway, as an ugly workaround I would concatenate the field with an apostrophe at the start and then export to csv, the ' will still be there but not really easy to see.
0 -
User wants a report in tabular/excel format.
0 -
Ok once more:
Excel is the issue. Excel is converting. Excel is being stupid.
Tell your users to be smarter and choose the less lazy option of double-clicking but in Excel go "Data" -> "From Text" -> Import the CSV -> In the import mask define the columns as TEXT and not STANDARD. Because it's text. "Standard" just will give you the same Excel rubbish.
0 -
*cringe* Please don't
0 -
Regret that I said that. Tried to convince OP and even gave the same suggestion about import from csv but he/she wouldn't accept...
0 -
I know and that's even more painful
0
