Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Data triming while exporting the report output to .csv
nsuraj
Hi
I am Using BIRT for reporting in my project.
The report shows correct value for amount(String) as 123456789123, but when i try to export the same report into csv, the csv file shows same amount as 1.234E11.
I want to value as 123456789123 in csv too.
Please help
Thanks
Find more posts tagged with
Comments
micajblock
<blockquote class='ipsBlockquote' data-author="'nsuraj'" data-cid="110082" data-time="1349238729" data-date="02 October 2012 - 09:32 PM"><p>
Hi<br />
I am Using BIRT for reporting in my project.<br />
The report shows correct value for amount(String) as 123456789123, but when i try to export the same report into csv, the csv file shows same amount as 1.234E11.<br />
I want to value as 123456789123 in csv too.<br />
Please help<br />
Thanks<br /></p></blockquote>
<br />
How are you viewing the file? If in Excel, then Excel is formatting the data. Have you tried opening the file in a text editor?
nsuraj
<blockquote class='ipsBlockquote' data-author="'mblock'" data-cid="110115" data-time="1349314793" data-date="03 October 2012 - 06:39 PM"><p>
How are you viewing the file? If in Excel, then Excel is formatting the data. Have you tried opening the file in a text editor?<br /></p></blockquote>
Hi mblock<br />
I am viewing the file in excel,<br />
The data get displayed correctly in text editor,<br />
But why is displaying 1.23E11 in excel even if datatype is String
micajblock
<blockquote class='ipsBlockquote' data-author="'nsuraj'" data-cid="110131" data-time="1349340583" data-date="04 October 2012 - 01:49 AM"><p>
But why is displaying 1.23E11 in excel even if datatype is String<br /></p></blockquote>
<br />
Ask Microsoft. If you make the column wide enough for the whole number to display it might work. Bottom line is that BIRT is exporting correctly, we have no control of what Excel does to CSV.
wwilliams
<blockquote class='ipsBlockquote' data-author="'nsuraj'" data-cid="110131" data-time="1349340583" data-date="04 October 2012 - 01:49 AM"><p>
Hi mblock<br />
I am viewing the file in excel,<br />
The data get displayed correctly in text editor,<br />
But why is displaying 1.23E11 in excel even if datatype is String<br /></p></blockquote>
Back in the old days this worked for numeric text ="123456789"
