Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Add Zero in blank space in a column
Add Zero in blank space in a column [message #655290] Sat, 19 February 2011 00:26 Go to next message
JP Redro is currently offline JP RedroFriend
Messages: 177
Registered: July 2009
Location: India
Senior Member


I am using BIRT 2.2.1, as per my requirement i need to add zero if the char is blank in the column.

my column count is 6 char : 123456
if the number i get 1234 then i need like 001234

Please assist me.

Thanks in advance.
Re: Add Zero in blank space in a column [message #655345 is a reply to message #655290] Sat, 19 February 2011 17:03 Go to previous message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 205
Registered: July 2009
Location: Houston TX
Senior Member

Convert the number to string
Prepend with zeroes ("000000" + number.toString)
Take the rightmost 6 characters (some variant of substring call)

Sorry I dont have the Java functions in mind. Also you can do this in the SQL.
Previous Topic:Birt Expression Help Needed
Next Topic:Howto create a Timedimension
Goto Forum:

Current Time: Wed Mar 29 05:30:51 GMT 2017

Powered by FUDForum. Page generated in 0.02875 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software