Replacing empty fields

[stphnwl]

Hi,

I have a field that is either "TC", "26", or blank.

I'm trying to replace all of the blanks with a word so that I can perform a Join on the result.

I'm using the formula IIF(ISNULL([procedure]),"Global",[procedure]) but this does not seem to be working. The blank fields continue on as blanks.

Is there some other way to do this?

Thank you!

[MarqueeCrew · Accepted solution]

try:

IIF(IsEmpty([Procedure]),"Global",[Procedure])

if that doesn't work....

IIF(IsEmpty(Trim([Procedure])),"Global",[Procedure])

Cheers,

Mark

Updated logic (missed an end paren).

[stphnwl]

Hi Mark,

Thanks for the suggestions!

I'm receiving the error "Wrong number of parameters for the function "ISEMPTY".

[stphnwl]

By the way, is this still a function in 11.0? I should have specified.

[MarqueeCrew]

sorry.  i fixed the logic :)

[MarqueeCrew]

yes.  good for 11 and probably all future releases.

[stphnwl]

Thanks a bunch as always!