Replacing Nulls with a String

[staceygreene]

I have a simple problem. I need replace all Null values in a column with the word " Terminal " I need to keep everything else the same in the column. Anyone have a solution ? 

[DataNath · Accepted solution]

Hey @staceygreene, you can just use a Formula tool with the following expression - replacing FieldName with your field:

if IsNull([FieldName]) then 'Terminal' else [FieldName] endif

[staceygreene]

Thank you ! That worked

[ImanJanahmadi]

It was so helpful, thank you