Eclipse Community Forums: BIRT » Computed column: email

Help

Home

Home » Archived » 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 11: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 15: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!

Report message to a moderator

Previous Topic:	Transform table
Next Topic:	Cryptic Error Message when Running Report on Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:32:26 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter