BI Publisher (MOSC)

MOSC Banner

Results of If and Else both show up.

edited Dec 3, 2013 9:13AM in BI Publisher (MOSC) 9 commentsAnswered

I'm reformatting a field called Description___Local_ID20.  The value of the field is:

VEINTINUEVE MIL SEISCIENTAS TREINTA Y UNA CON 44/100 *******************************

I have the following code to re-format the output:

<?xdofx:if contains(Description___Local_ID20, 'Y UNA CON')?>

<?xdofx:'('||replace(replace(replace(replace(Description___Local_ID20, 'UNA', 'UN'), 'CON', 'PESO'), '*', ''), 'CIENTAS', 'CIENTOS')||'M.N.'||')'?>

<?else?>

hello

The result of the code is:

(VEINTINUEVE MIL SEISCIENTOS TREINTA Y UN PESO 44/100)hello

Why does the output show both what is in my If statement and what is also in the Else statement?  'hello' should not be showing up.  Where am I going wrong with the syntax?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center