Skip to Content
0
Former Member
Jan 23, 2015 at 06:08 AM

Trim the text from right hand side - Need help

270 Views

Hi,

I need to trim the text from R H S.

Background: I'm trying pass parameter from Design studio to Webi using Hierarchy variable.

It is working fine for constant value like

..OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AT2qMP7vYG1Muweram5cqM&sRefresh=Y&lsSPROFIT_CENTER=0001AAAAA

But, I need to pass the parameter from Design studio with different value each time.

Problem:

I'm using following script to get key for hierarchy value and values are getting in following format.

IT_HEADING.setText(DS_1.getFilterExt(<Dimension>));

+0001AAAAA(Text\ Node)

+0001BBB(Text\ Node)

+0001CCCCCC(Text\ Node)

Webi won't work with this. So i need to trim the text in the following format.

0001AAAAA

0001BBB

0001CCCCCC

Please help me here.

Thanks & regards,

Suresh