How to replace NULL value in Mapper

[sbhaskar85]

I have a file reader in my mapping. One of the column in the file contains NULL value. I am connection a mapper after the file reader. Is there any way to replace the NULL value with number? Tried using replace/replaceALL function but didn’t get the intended result

[Ajay_Chawda]

Hi Bhaskar ,
You can use ternary operator to replace null value with number.
eg:- $firstname==‘null’?0:‘’

[sbhaskar85]

Ajay_Chawda:

$firstname==‘null’?0:’’

It worked. Had to remove the quotes before and after NULL.the condition looked like
$firstname==null?2:$firstname

Thanks much for the idea