Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Split column (Split Column based on Symbol "|")
Split column [message #638423] Thu, 11 November 2010 04:39 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. I would like to split column text based on "|" symbol. Here is my text, please suggest me.

ART. OF STONE OR MINERAL,OTHER|ARTICLES OF STONE OR OF OTHER MINERAL SUBSTANCES

Thanks,
JP


Thanks,
JP
Re: Split column [message #638541 is a reply to message #638423] Thu, 11 November 2010 10:21 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

JP

you should be able to use an expression like:

var tst = "ART. OF STONE OR MINERAL,OTHER|ARTICLES OF STONE OR OF OTHER
MINERAL SUBSTANCES ";
tst.split("|")[1]; //or [0] for the first string

Jason

On 11/11/2010 4:39 AM, JP wrote:
> Experts,
>
> I am using BIRT 2.2.1. I would like to split column text based on "|"
> symbol. Here is my text, please suggest me.
>
> ART. OF STONE OR MINERAL,OTHER|ARTICLES OF STONE OR OF OTHER MINERAL
> SUBSTANCES
>
> Thanks,
> JP


Jason Weathersby

BIRT Exchange
Previous Topic:Export report as csv (unicode)
Next Topic:Report parameter picker date
Goto Forum:
  


Current Time: Mon Apr 21 03:06:53 EDT 2014

Powered by FUDForum. Page generated in 0.28567 seconds