Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
double quotes in a field value in flat file datasource
Migrateduser
hello all,<br />
i am currently using BIRT eclipse designer to design a xls report using a flat file datasource(PSV file).<br />
The problem i'm facing is that in my datasource file i have fields containing double quotes(") for eg:<br />
<br />
SOURCE_TYPE|DATA_VALUE<br />
medical|"$"128.50<br />
medical|"$"524.20<br />
pharmacy|"$"6982.50<br />
<br />
and while creating dataset from birt report desinger it gives following error:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot fetch the next data row.
org.eclipse.datatools.connectivity.oda.OdaException: Invalid flat file format
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:143)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:214)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:105)
at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.<init>(SimpleResultSet.java:90)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:996)</pre>
<br />
i know this error is due to that double quote in the DATA_VALUE field cause as i remove those quotes it runs fine.So how to handle such data values.
Find more posts tagged with
Comments
There are no comments yet