How to find the last string value in dynamic object?

[Former Member]

Hi All,

I am trying to find the last string value in dyanamic objects,Any one have solution for this.

Ex:

my data :12347-ebjdone-525-ecgfjf-25236-defdafgdeg

And i want to show the output is :defdafgdeg

Any ideas:

Thanks

Srini

[former_member207342]

Please provide some more information

Which database

How are you using 'Dynamic Objects'

--Kuldeep

Edited by: Kuldeep Chitrakar on Feb 12, 2010 7:43 AM

[former_member207342]

For oracle try using oracle function.

e.g.

SELECT  reverse(substr(reverse('12347-ebjdone-525-ecgfjf-25236-defdafgdeg'),1,instr(reverse('12347-ebjdone-525-ecgfjf-25236-defdafgdeg'),'-','1'))) from dual

Object definition might look like:

reverse(substr(reverse({ObjectName}),1,instr(reverse({ObjectsName}),'-','1')))

Regards,

Kuldeep

Edited by: Kuldeep Chitrakar on Feb 12, 2010 8:12 AM

[Former Member]

Hi,

Thanks for quick reply,but I want to find the last string give WebI report not in Universe.Dyanamic objects mean universe object,that will change in run time.

So can you provide me the logic to find the last string in WebI report object.