Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Whitespaces are ignored
dalepraneeth
we need to generate a report while reading individual lines from a text file.<br />
<br />
some text files might contain <strong class='bbc'>whitespaces in beginning of the line</strong>.<br />
<br />
But <strong class='bbc'>Birt is ignoring the whitespace</strong> and starting from the first character it encounters.<br />
<br />
please help me with a solution.<br />
<br />
thanks in advance.
Find more posts tagged with
Comments
dalepraneeth
<img src='
http://img256.imageshack.us/img256/880/textpic.png'
alt='Posted Image' class='bbc_img' /><br />
<br />
<img src='
http://img80.imageshack.us/img80/473/pdfpic.png'
alt='Posted Image' class='bbc_img' /><br />
<br />
<br />
<br />
As you can see above pictures ... one is a text file and later is BIRT report ....<br />
<br />
In birt the whitespaces are getting ignored ....
mwilliams
Can you create a report and a simple text file that will show what you're doing that I can run?
dalepraneeth
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="93992" data-time="1326387071" data-date="12 January 2012 - 09:51 AM"><p>
Can you create a report and a simple text file that will show what you're doing that I can run?<br /></p></blockquote>
<br />
<br />
I will try to upload the documents, mean while i will explain what we were doing here.<br />
<br />
We were reading a text file and each line is one data row . Well some rows contain whitespaces in the beginning of the row. But birt is just ignoring those spaces which looks like the text moves forward in pdf document when we generate the report.<br />
<br />
So, is there anything that makes birt consider those whitespaces in the beginning of the line ??
mwilliams
How are you reading in the text file? With the flat file dataSource or with a scripted dataSource?
dalepraneeth
The solution for this problem is goto:
properties-> Format string -> Preserve white spaces : string with leading white spaces
mwilliams
Great! Thanks for the update!
PascalH
<p>Topic is old know but i am stuck with the same Problem using an Excel Data Source and cant find the property Setup as mentioned before. What Properties i have to Change? From Data Source or Data Set? In my case it is the row in the Excel data on which i want to use a join on. So Birt compares the Excel data source with one from Oracle DB. in Oracle the whitespace is not ignored and in Excel it is.. Means i cannot join correctly the datasets.</p>