Match Function is excluding null values

[#1]

Im using the Match function to exclude a particular value however it also seems to be removing null values . Does anyone have any ideas ?

[swuehl]

Could you post your expression / statement and some sample data. And what you expect to get?

[Anonymous]

How about something like

If ( isnull[[YourField] or match(........) , .....................

[Anonymous]

Can we use below expression

if(not(isnull([Field])), Match(...))

[#5]

Sorry my expression is

WHERE (FieldName = 'CountryStatus'

AND Match(FieldValue, 'Inactive) = 0)

;

this removes all Country statues which are 'inactive'. However it also removes all records that don't have a CountryStatus assigned ie nulls which is not what I want.

[Anonymous]

WHERE (FieldName = 'CountryStatus'

AND

( Match(FieldValue, 'Inactive') = 0 or isnull(FieldValue) )

[swuehl · Accepted solution]

Seems to work for me:

LOAD *

WHERE FieldName = 'CountryStatus' and not FieldValue = 'Inactive';

LOAD recno() as ID, FieldName, if(len(trim(FieldValue)),FieldValue, NULL()) as FieldValue INLINE [

FieldName, FieldValue

CountryStatus, Active

CountryStatus, Inactive

CountryStatus,

];

[jonas_rezende]

Hi.

When Country Status is null, which is value of FieldValue?

[#9]

Hi Bill I tried this however it returns values with CountryStatus as Inactive

[swuehl]

Or if you want to stick to Match():

WHERE FieldName = 'CountryStatus' AND Rangesum(Match(FieldValue,'Inactive'))=0;