Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I only want to load Companies with strings containing Sears but not Companies with strings containing Sears and Lowes or just Lowes. Can you help?
DryerDetails:
LOAD * INLINE [
Dryer Model, Cost, Companies
NED4655EW, $398, Home Depot Lowes Sears
WED5000DW, $498, P.C. Richard & Son Sears
MEDC465HW, $498, Lowes P.C. Richard & Son
DVE50M7450P, $598, Sears Lowes
DVE52M7750W, $999, Sears P.C. Richard & Son Home Depot
];
Where WildMatch([Companies],'*Sears*' );
May be:
Where WildMatch([Companies],'*Sears*' ) and NOT WildMatch([Companies],'*Lowes*' );
May be:
Where WildMatch([Companies],'*Sears*' ) and NOT WildMatch([Companies],'*Lowes*' );