Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » substring

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

substring [message #142708]

Fri, 10 March 2006 13:30

No real name

Messages: 6
Registered: July 2009

Junior Member

Hi,

In the dataset, i want to make a computed column that contains the first 2
letters from row("ORDER")

In the expression builder i want to use the substr or substring
functionality, but i get a javascript error saying that the function does
not exists.

How can i get the first 2 digits of the string? Where can i find the right
syntax?

Report message to a moderator

Re: substring [message #142723 is a reply to message #142708]

Fri, 10 March 2006 13:37

mr. burns

Messages: 402
Registered: July 2009

Senior Member

Hello,

in the expression builder for the computed column try following code:

row["ORDER"].substring(1,3)

if row["ORDER"] equals e.g. ABCD it will return AB

hope that helps!

Report message to a moderator

Re: substring [message #142733 is a reply to message #142708]

Fri, 10 March 2006 13:40

mr. burns

Messages: 402
Registered: July 2009

Senior Member

Hello,

sorry ;-) it must be:

row["ORDER"].substring(0,2) // to show the 1st two letters, beacause arrays
start with index zero!

if row["ORDER"] equals e.g. ABCD it will return AB

hope that helps!

Report message to a moderator

Previous Topic:	Problems Display
Next Topic:	log file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 15:13:15 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter