Exclude in Search in a Load Statement

[Anonymous]

I have a load statement which is as follows

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='D/M/YYYY';

SET TimestampFormat='D/M/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-SG';

LOAD active,

    purchase_ok,

    rental,

    sale_ok,

    standard_price,

    sale_delay,

    ean13,

    default_code,

    produce_delay,

    mes_type,

    DESC,

    procure_method,

    type,

    list_price,

    supply_method,

    [Supplier/Supplier],

    [Supplier/Supplier Product Code],

    [Supplier/Supplier Product Name],

    [Supplier/Minimal Quantity],

    [Supplier/Delivery Lead Time],

    [Expense Account/Name],

    [Income Account/Name],

    [Supplier Taxes/Tax Name],

    [Customer Taxes/Tax Name]

FROM

(ooxml, embedded labels) where WildMatch(DESC, '*HS25*', '*HS 25*' , '*HS-25*' ,'*LONG*');

I need to exclude  DESC  line item if it contains '*PR24*'  or '*PR-24*'or  '*PR 24* or  '*SHORT*'

How do I change the WildMatch code?

Thanks

[MK_QSL · Accepted solution]

where

(

               WildMatch(DESC, '*HS25*', '*HS 25*' , '*HS-25*' ,'*LONG*')

and  NOT WildMatch(DESC, '*PR24*' , '*PR-24*', '*PR 24* , '*SHORT*')

)