Capturing multiple string value in a presentation variable

Saro

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

Dear Saro,

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

Saro

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

Try LocateN or Position Function and use it in substring.

[Deleted User]

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

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

Thanks christain and asim for your time/replies.

Regards,

Saro

Saro

This syntax dint work joel

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

Saro