[litojulian]

Hi,

I have a record which is in bit data type(example: F2F0F0F9F0F8F0F4, F1F3F6F5F1F7) How to display the record omitting letter "F"?, end result should be 20090804, 136517.

I had tried this method in initialize script...
function mySplit(str){
var myString = str;
var mySplitResult = myString.split("F");
return mySplitResult;
}

and i got this error

The following items have errors:


Data (id = 198):
+ A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: Java class "[B" has no public instance field or method named "split".
Script source: null, line: 0, text:
<compiled script> (Element ID:198)

..... any idea? Thanks

[JasonW]

Where are you getting the data from and what data type does BIRT list it as?

Jason

[litojulian]

Hi Jason,

I am getting from AS400, char() for bit data(8). The record sample is F2F0F1F2F0F6F2F0, when i use blob type it display as it is is F2F0F1F2F0F6F2F0, but when use String it display FFFFFFF2 FFFFFFF0 FFFFFFF1 FFFFFFF2 FFFFFFF0 FFFFFFF6 FFFFFFF2 FFFFFFF0. Just wasted to out 20120620.
Thanks

[litojulian]

Hi, I had tried this approach and it works:

Edit Expressions:

var mystring = new Packages.java.lang.String(dataSetRow["yourField"], "IBM01140");
mystring;

litojulian, on 01 July 2012 - 05:18 PM, said:

Hi Jason,

I am getting from AS400, char() for bit data(8). The record sample is F2F0F1F2F0F6F2F0, when i use blob type it display as it is is F2F0F1F2F0F6F2F0, but when use String it display FFFFFFF2 FFFFFFF0 FFFFFFF1 FFFFFFF2 FFFFFFF0 FFFFFFF6 FFFFFFF2 FFFFFFF0. Just wasted to out 20120620.
Thanks

[JasonW]

So it is working?

Jason