Capturing multiple string value in a presentation variable

Saro · Oct 17, 2017 4:49AM

Hi christian,

This is what my real scenario and hence inorder to tackle this only im finding to get the string values in a variable inorder to use substring to get the last month name alone.

Saro

asim cholas · Oct 17, 2017 4:54AM

Dear Saro,

Why not find the last occurance of , and then take a substring from it?

Saro · Oct 17, 2017 4:57AM

Hi Asim,

Im using obiee 11.1.1.7.150120.

Why not find the last occurance of , and then take a substring from it?

How can i do that. Kindly explain it.

Thanks,

Saro

asim cholas · Oct 17, 2017 5:03AM

Try LocateN or Position Function and use it in substring.

[Deleted User] · Oct 17, 2017 5:08AM

SUBSTRING('@{v_Period}{PleaseBeProperAndPutDefaultsLikeDEC-17}' FROM LENGTH('@{v_Period}{PleaseBeProperAndPutDefaultsLikeDEC-17}')-5 FOR 3)

Ugly as sin but that yields "DEC"; but as I said if you have to do contortions like this it most probably points to a seriously messed usage of the solution.

asim cholas · Oct 17, 2017 5:08AM

if it is in the format JAN-17 use below

substring('@{PVT}',Locate(';','@{PVT}',-1)+1,6)

or if you have

JAN-2017

substring('@{PVT}',Locate(';','@{PVT}',-1)+1,8)

For JAN only

substring('@{PVT}',Locate(';','@{PVT}',-1)+1,3)

Saro · Oct 17, 2017 8:23AM

Thanks christain and asim for your time/replies.

Regards,

Saro

Saro · Oct 17, 2017 8:25AM

This syntax dint work joel

('@{v_period}['@']')

Saro

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Capturing multiple string value in a presentation variable

Answers