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
