Cast String to Number in BIRT
Options
<p>There are a couple of options in BIRT when using CSV as a data source and you want to cast a String as a number in order to do further formating (currency, etc.):</p><ol><li>Double-click on the data field and select Decimal from the "Data Type" dropdown. Then, you will be able to format via the "Format Number" property of the data.</li><li>You can set the data type in the second row of the CSV file. Make sure that you set the flag on the data source which indicates to use the second row as a data type. Then, you will be able to format via the "Format Number" property of the data.</li></ol>
0
Categories
- All Categories
- 108 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management