I'm trying to get better with pattern matching but even after years of using MMA it's still a murky concept. The docs are actually pretty good in this regard but I still struggle. In this situation I have a list of real estate items (that are strings) which I'm trying to clean up. I've tried the below 2 methods and have not been able to delete the "HVAC" elements required from this list.

DeleteCases[featureList, StringContainsQ [#,"HVAC"] & ]


DeleteCases[featureList, __~~"HVAC"~~__]

Both return the same list back:

{ML #,Property Type,SubSpcSqFt,Land Sz SF,Building Type,List Date,Yr Blt,Address,Area,Class,Clear Ceiling Ht (Feet),Lot Frontage (ft),Lot Depth (ft),Zone,Price,Sale Type,Transaction Type,Zoning/Land Use,Amenities-HVAC System,Building Type-Freestanding,HVAC-See Realtor Remarks,HVAC-Baseboard,HVAC-Central A/C,HVAC-Common Water Heater,HVAC-Electric,HVAC-Forced Air,HVAC-Heat Pump,HVAC-Hot Water,HVAC-In-Floor,HVAC-Make-Up Air,HVAC-Mixed,HVAC-None,HVAC-Radiant,HVAC-Rooftop,HVAC-Separate Controls,HVAC-Separate HVAC Units,HVAC-Separate Water Heaters,HVAC-Space Heaters,HVAC-Steam,HVAC-Window A/C}

What is the correct way to filter out any string containing "HVAC"?

featureList = {"ML #", "Property Type", "SubSpcSqFt", "Land Sz SF", 
   "Building Type", "List Date", "Yr Blt", "Address", "Area", "Class",
    "Clear Ceiling Ht (Feet)", "Lot Frontage (ft)", "Lot Depth (ft)", 
   "Zone", "Price", "Sale Type", "Transaction Type", 
   "Zoning/Land Use", "Amenities-HVAC System", 
   "Building Type-Freestanding", "HVAC-See Realtor Remarks", 
   "HVAC-Baseboard", "HVAC-Central A/C", "HVAC-Common Water Heater", 
   "HVAC-Electric", "HVAC-Forced Air", "HVAC-Heat Pump", 
   "HVAC-Hot Water", "HVAC-In-Floor", "HVAC-Make-Up Air", 
   "HVAC-Mixed", "HVAC-None", "HVAC-Radiant", "HVAC-Rooftop", 
   "HVAC-Separate Controls", "HVAC-Separate HVAC Units", 
   "HVAC-Separate Water Heaters", "HVAC-Space Heaters", "HVAC-Steam", 
   "HVAC-Window A/C"};

The following are all equivalent

DeleteCases[featureList, _?(StringContainsQ[#, "HVAC"] &)]

DeleteCases[featureList, _?(StringContainsQ["HVAC"])]

DeleteCases[featureList, _?(StringMatchQ[#, ___ ~~ "HVAC" ~~ ___] &)]

DeleteCases[featureList, _?(StringMatchQ[___ ~~ "HVAC" ~~ ___])]

Select[featureList, StringFreeQ["HVAC"]]
| improve this answer | |
  • $\begingroup$ It would be fine to add he alternative solution : Select[featureList, ! StringContainsQ[#, "HVAC"] &] $\endgroup$ – andre314 Mar 7 at 15:03
  • $\begingroup$ Excellent answer. I found this doc helpful in understanding the behaviour of this answer: reference.wolfram.com/language/ref/PatternTest.html $\endgroup$ – BBirdsell Mar 7 at 16:37

In addition:

DeleteCases[featureList, str_/;StringContainsQ[str, "HVAC"]]

But perhaps combined with a regular expression is more powerful?

For example (delete cases where str begins with 'HVAC' only):

 DeleteCases[featureList, str_/;StringContainsQ[str, 

{ML #, Property Type, SubSpcSqFt, Land Sz SF, Building Type, List Date, Yr Blt, Address, Area, Class, Clear Ceiling Ht (Feet), Lot Frontage (ft), Lot Depth (ft), Zone, Price, Sale Type, Transaction Type, Zoning/Land Use, Amenities-HVAC System, Building Type-Freestanding}

And, of course, there is also Pick

| improve this answer | |
  • $\begingroup$ Ah. Good answer too. I was more confused about patterns but there are a lot of regex gurus out there. $\endgroup$ – BBirdsell Mar 7 at 21:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.