Skip to main content

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: 181
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: 212
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:multiple masterpages (page orientation)
Next Topic:Birt Expression Help Needed
Goto Forum:

Current Time: Fri Jun 22 03:59:28 GMT 2018

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

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

Back to the top