Replacing multiple strings for many occurance of single string in OBIEE a
886413Oct 21 2011 — edited Jul 17 2012Hi,
I have a requirement like i need to replace a Particular string('_') that occur three times in a string.I need to replace different strings for each occurance of ('_').
My requirement is like this,
My string is 'A_B_C_D' and I need to replace first'_' as 'E=' second '_' as 'F=' third '_' as 'G='.
and the final string should be I=A E=B F=C G=D...
Can any one help me in the logic or else help me how to use the existing functions in answers.