Is there any way to use another function as fillnull to fill null spaces?

[KalebeRS]

Hello.

I have a table with a column for Releases, in this case, a bunch of them does not have releases. I used the fillnull function in this specific field, but it's not working. In this table I have other columns that I have null values as well, but for the other ones the fillnull worked. How can I do the same for the releases field?

[ITWhisperer · Accepted solution]

Null is not the same as an empty string - perhaps your Releases field has an empty string or is just spaces - try something like this

| eval Release=if(trim(Release)="","No release available",Release)