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
But, I need to pass the parameter from Design studio with different value each time.
I'm using following script to get key for hierarchy value and values are getting in following format.
Webi won't work with this. So i need to trim the text in the following format.
Please help me here.
Thanks & regards,