fieldName <> 'name (-)' - what is the meaning?

[#1]

Hi all,

Would like to know the meaning of the expression: fieldName <> 'name ( - )'

what does it check?

Thanks,

Boris

[mdmukramali]

Dear,

<> use for NOT EQUAL TO.

if we want to exclude some records form any table which are have the fieldName  with values name(-).

sample Example:

Test:

LOAD * Inline

[

ID,Personname

101,name(AAA)

102,name(-)

103,name(BBB)

104,name(DDD)

105,name(-)

];

NoConcatenate

LOAD *

Resident Test

Where Personname<>'name(-)' ;

DROP Table Test;

[#3]

It is not what I meant.

all the values in FieldName are : 'name (abc)'    ' name (afd)'   'name (ghf)'   etc.

I don't have any 'name ( - ) ' in my data.

I'm trying to figure out a script someone else wrote.

Thanks, 

[#4]

Are you checking the Source Data ?

They are doing this validation to expect this type of data in the future.

fieldName <> 'name ( - )' : the meaning for this expression is please exclude the all the FieldName values like name ( - )