topic Re: Load one string but not the other in App Development

Load one string but not the other

Anonymous — Fri, 07 Dec 2018 03:30:06 GMT

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*' );

Re: Load one string but not the other

laksyelugoti — Fri, 07 Dec 2018 04:32:04 GMT

One option is using 2nd Resident load, below is sample code..
1. First load all companies with 'Sears'
2. From above records, Filter out 'Sears' companies with 'Lowes'

DryerDetails_all_Sears:
noconcatenate
Load *
Resident DryerDetails
wildmatch(Companies,'Sears') << Load all companies with 'Sears'

DryerDetails_Final:
noconcatenate
LOAD * Resident DryerDetails_all_sears
NOT wildmatch(Companies,'Lowes') << Load all companies with 'Sears' without 'Lowes'

Re: Load one string but not the other

tresB — Fri, 07 Dec 2018 04:54:29 GMT

May be:

Where WildMatch([Companies],'*Sears*' ) and NOT WildMatch([Companies],'*Lowes*' );