2

Cell E1 contents has product tags:

Sets,Cuff,Bra,Panty,Garterbelt,Costume,Blouse,Skirt,Pantyhose,Corset,Headwear,Lace,Crotchless,Thong,Negligee,French Maid,Nurse,Trunk,Jock,Brief,Boxer,Athletic,Mesh,Fishnet,Fencenet,Lowrise,Micro,G String,Thigh Highs,Suspender,Bow,Boyshort,Babydoll;Teddy,Lace,Tube Dress,Boob Tube,Chemise,Glitter,Leopard,Satin,Halter,Eyemask,Ruffle,Kimono,Schoolgirl,Bodysuit,Camisole,Cami,Bodystocking,Bustier,Gloves,Tap Shorts,Shiny,Split Crotch,Ribbon,Open Crotch,Stretch,Fingerless,Leather

Column D2:D has all the lingerie product titles like "Black Garterbelt and Suspender"

So the idea is to print in column E2:E comma separated tags that are in the product tile from column D

enter image description here

1 Answer 1

1

Here's a formula that does this: the entry for E2 is shown but it can be dragged down.

=join(",", filter(split(E$1,","), regexmatch(D2, "(?i)\b" & split(E$1,",") & "\b"))) 

Explanation:

  • split(E$1,",") split the set of tags into an array & "(?i)\b" & split(E$1,",") & "\b" turns each tag into a regular expression which means: match this string as a whole, case-insensitive.
  • regexmatch records True if the product name matched the tag, and False if no match.
  • filter filters the array of tags according to the output of regexmatch
  • join joins the filtered array into a comma-separated string.
1
  • Mr Human... this is EXACTLY the magic sauce!! Thank you sir...
    – Nauti NZ
    Oct 20, 2015 at 2:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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