replace if null

[r.snijders]

Good morning all,

Using Jaspersoft in combination with Coresuite.  I made a Text field within the report and enter the next line in the expression Editor. : udfValue("ServiceCall", 13, $F{serviceCall.id}, "FSM_Adresnaam") .

When it is empty it return's Null

But i can not figure out how to replace "Null" in to "". 

I tried the to use: udfValue("ServiceCall", 13, $F{serviceCall.id}, "FSM_Adresnaam").replace("null", "").trim() 

any ID how to replace?

[gustavofarias]

If in the end yout expression evaluates to null, you can always use "Blank when null" text field property to make it vanish.

[r.snijders]

This is not possible because there is always a value and that is null.

[gustavofarias]

Have you tried the built in replace function?

see attachment

 

[r.snijders]

Good afternoon.

thank you for your reply. This did the trick and also found the leave blank when is null optie. 

Was on a other tab. Thanks you all for the help.