The Condition with "contains"

[#1]

Hi guys!

I need to write a condition like it the value contains "A" then I should exclude them in my script.

Does anybody know how can write this condition?

[Anonymous]

you  can  share your script please?

[jpenuliar]

If it is in your Load script, you can make use of "where" clause.

e.g.

Load A,A+B+C resident tab1 where A>B;

[Anonymous]

one of the ways to do it is, put this filter in your where clause,

Table1:

Load

yourfield,

//otherfields

Where substringcount( yourfield,'A') >0

[jpenuliar]

where A = "Good"

where A <> "Bad"

[vvvvvvizard]

create a new table

new_table :

load *

resident old_table_name

where not fieldname =wildmatch(fieldname,'*contains text here*');

[Colin-Albert]

To exclude all records that contain the string 'XYZ' in field A use index in the where clause

load

     A,

     B,

     C,

     etc

from .....

where index(A, 'XYZ') = 0

;