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 Redro
Messages: 167
Registered: July 2009
Location: India
Senior Member

Experts,

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

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

Please assist me.

Thanks in advance.
JP.


Thanks,
JP
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. Polunsky
Messages: 199
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 Sep 19 05:53:32 GMT 2014

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

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