# EmptyIsNull Script and chart function

The EmptyIsNull function converts empty strings to NULL. Hence, it returns NULL if the parameter is an empty string, otherwise it returns the parameter.

Syntax:

EmptyIsNull(exp )

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFunctions/EmptyIsNull.htm)

#### Examples and results:

Scripting examples

| Example | Result |
| --- | --- |
| `EmptyIsNull(AdditionalComments)` | This expression will return as null any empty string values of the AdditionalComments field, instead of empty strings. Non-empty strings and numbers are returned. |
| `EmptyIsNull(PurgeChar(PhoneNumber, ' -()'))` | This expression will strip any dashes, spaces and parentheses from the PhoneNumber field. If there are no characters left, the EmptyIsNull function returns the empty string as null; an empty phone number is the same as no phone number. |