Logical functions

This section describes functions handling logical operations. All functions can be used in both the data load script and in chart expressions.

Note: Both IsNum and IsText return 0 if the expression is NULL.


The following example loads an inline table with mixed text and numerical values, and adds two fields to check if the value is a numerical value, respectively a text value.

Load *, IsNum(Value), IsText(Value) Inline [ Value 23 Green Blue 12 33Red];

The resulting table looks like this:

Value IsNum(Value) IsText(Value)
23 -1 0
Green 0 -1
Blue 0 -1
12 -1 0
33Red 0 -1

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?