Eclipse Community Forums: BIRT » Computed column: email

Help

Home

Home » Eclipse Projects » BIRT » Computed column: email(search computed column function)

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

Computed column: email [message #662881]

Fri, 01 April 2011 07:14

gin1975
Messages: 30
Registered: April 2011

Member

Hello,

Do you know any features that could be applied in a "Computed column" that is able to convert a row whose content is a string (a email. Example: email1@domain.com) and return another string that shows only the following string: domain (or domain.com) of this email.

Thanks!

Report message to a moderator

Re: Computed column: email [message #662961 is a reply to message #662881]

Fri, 01 April 2011 11:24

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

I did it like this once in a computed column:

var cls = new Packages.java.lang.String(row["emailaddress"]);
os = cls.substring( cls.indexOf("@")+1);

Jason

On 4/1/2011 7:14 AM, gin1975 wrote:
> Hello,
>
> Do you know any features that could be applied in a "Computed column"
> that is able to convert a row whose content is a string (a email.
> Example: mailto:email1@domain.com) and return another string that shows
> only the following string: domain (or domain.com) of this email.
>
>
> Thanks!

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	Adding Column to Table
Next Topic:	Cryptic Error Message when Running Report on Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 21:25:28 EDT 2013