how to get rid of nulls in a concatenated string?

[dprogrammer]

I have a concatenated string like the following and some values can be null. I want the null values to be "" (blank) so that I don't see nulls. But its not working.

$F{AMOUNT1}==null?"":$F{AMOUNT1}+"n"+
$F{AMOUNT2}==null?"":$F{AMOUNT2}+"n"+
$F{AMOUNT3}==null?"":$F{AMOUNT3}+"n"

Current outPut:

9000000
6000000
null

Desired output:

9000000
6000000
 

 

[svenn]

If the value is a String it could contain the text "null" instead of a NULL value. You could also look for the condition

$F{AMOUNT3}.equals("null")

 

[keats76]

try something like:

$F{AMOUNT1}==null?"":$F{AMOUNT1}.toString()+"n"+

instead ...

[Gaby38]

Hello,

I am not sure to well understand your problem, but, as for me, everytime I have to concatenate strings with some of them possibly null, I do that in the sql query with the nvl function.

In your case (oracle syntax) :

select nvl(to_char(Amount1),'')||nvl(to_char(Amount2),'')||nvl(to_char(Amount3),'') as Field1 ....

Hope this helps

Gaby

[yo1832]

The best option:

Go -> Edit -> Report properties -> i18n

3 combo list -> Cuando falte un tipo de recurso (I have in spanish)

select blank, this by default is null because is field dont have data print null.

Now in your report, if a fields dont have data this print blank.

 

Other Option:

($F{AMOUNT1}.equals(new String("null"))?new String(""):new String($F{AMOUNT1}).concat("n"))

 

I dont know if this is null or NULL or Null