If a field contains a certain word, display nothing in that field

[analystdude96]

As the title says, I want my app to show the field as blank/empty when that field contains a certain word. For example:

=if(match([Location],'*France*'),BLANK))

I am not sure what the syntax is to display it as blank or empty however. Any help would be appreciated. Thank you.

[Ivan_Bozov]

Try this:

IF(WILDMATCH(Location, '*France*'),NULL(),Location)

or

IF(WILDMATCH(Location, '*France*'),'',Location)