nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bit Data Type Conversion

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

Find more posts tagged with

Comments

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; 
 
 
<blockquote class='ipsBlockquote' data-author="'litojulian'" data-cid="106483" data-time="1341191907" data-date="01 July 2012 - 06:18 PM">
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 </blockquote>

JasonW

So it is working?

Jason