Eclipse Community Forums: BIRT » Add Zero in blank space in a column

Help

Home

Home » Archived » BIRT » Add Zero in blank space in a column

Show: Today's Messages :: Show Polls :: Message Navigator

Add Zero in blank space in a column [message #655290]

Sat, 19 February 2011 00:26

JP Redro

Messages: 181
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

Report message to a moderator

Re: Add Zero in blank space in a column [message #655345 is a reply to message #655290]

Sat, 19 February 2011 17:03

Richard A. Polunsky

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.

Report message to a moderator

Previous Topic:	multiple masterpages (page orientation)
Next Topic:	Birt Expression Help Needed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 07:26:01 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter