concat and NULL

[babarincairo]

Hi,

 

I have a problem with concatenation of two strings (from query) in a textfield.

 

I want to concat string A and B with a " - " between them. The "-" is present only if B is not NULL.

 

I use the following expression in the textfield :

 

Code:

(!($F{A}.equals(null)) ? $F{A} : ""«») +
(!($F{B}.equals(null)) ? " - " + $F{B} : ""«») 

 

But it doesn't work. If B is NULL, nothing is printed (normally A must be printed).

 

Can you help me ?

Thanks

Post edited by: babarincairo, at: 2006/11/07 08:25

[jpasquier]

I think that the following code will work :

 

Code:

($F{A} == null ? "" : ( $F{B} == null ? $F{A} : $F{A} + " - " + $F{B} )) 

[babarincairo]

the folloling code is working

 

($F{NOT_zone1}) + ($F{NOT_zone2} == null ? "" : " - " + $F{NOT_zone2}) + ($F{NOT_zone4} == null ? "" : " - " + $F{NOT_zone4}) + ($F{NOT_zone5} == null ? "" : " - " + $F{NOT_zone5}) + ($F{NOT_zone6} == null ? "" : " - " + $F{NOT_zone6})

[DerGuteMoritz]

Everyone, this is the only solution for that issue? Can't this be simplified using Groovy?