Find and keep specific rows that contains specific words

[Abby Chew]

Do we have any code or ways to find and keep only those with rows that contain specific words in the column? For example,
ID | Product Name | Gender
1 Vitamin D M
2. Natural Calcium. F
3. WHEY PROTEIN M
4. Calcium and Vitamin D F
I want to find and keep only rows that Product name column contain "calcium" in the product name. In this example, it should give back ID 2 and 4

Tank you

[Rich Goldstein]

you have been previously advised to use -dataex- to show example data; please read the FAQ and follow its advice

the answer to your question is "yes" and if you actually show real(istic) data, someone will provide exact code

[Abby Chew]

input double(seqn dsdpid) str200 dsdsupp
93703 18558 "KIRKLAND SIGNATURE CHILDREN'S COMPLETE MULTIVITAMIN GUMMIES"
93705 276 "VITAMIN A 8000 IU"
93705 596 "VITAMIN B-12 (COBALAMIN) 500 MCG"
93705 642 "VITAMIN C (ASCORBIC ACID) 500 MG"
93705 646 "VITAMIN D 1000 IU"
93705 17683 "NATURE'S BOUNTY OPTIMAL SOLUTIONS EXTRA STRENGTH HAIR, SKIN & NAILS ARGAN OIL INFUSED WITH BIOTIN 5000 MCG PER SERVING ANTIOXIDANTS C & E PLUS HYALURONIC ACID MULTIVITAMIN"
93705 18482 "OPTIMUM IRON FREE FORMULA CENTRAVITES 50 PLUS MULTIVITAMIN / MULTIMINERAL WITH LUTEIN & LYCOPENE"
93705 18567 "MAJOR NATURAL FIBER THERAPY 100% NATURAL PSYLLIUM HUSK FIBER BULK FORMING / DIETARY FIBER ORIGINAL TEXTURE"
93705 19478 "DEFAULT SUPER B-COMPLEX"
93708 2762 "DEFAULT FISH OIL"
93708 6382 "DEFAULT CALCIUM"
93708 19427 "CENTRUM SILVER ADULTS 50+ MULTIVITAMIN / MULTIMINERAL"
93710 17978 "TRI-VIT WITH FLUORIDE 0.25 MG AND IRON DROPS VITAMIN A, D, C, FLUORIDE & IRON DROPS WITH IRON QUALITEST"
93711 595 "VITAMIN B-12 (COBALAMIN) 2500 MCG"
93711 646 "VITAMIN D 1000 IU"
93711 5052 "MAGNESIUM 200 MG"
93711 11202 "NATURE MADE COQ10 200 MG"
93711 14384 "PURE ALASKA OMEGA 100% NATURAL OMEGA-3 WILD ALASKAN SALMON OIL 1000 MG COLD PRESSED EXTRA VIRGIN"
93711 18426 "NATURE'S BOUNTY ULTRA STRENGTH PROBIOTIC 10 CONTAINS CLINICALLY STUDIED STRAINS 20 BILLION LIVE PROBIOTIC CULTURES 10 PROBIOTIC STRAINS"
93711 18579 "BLUEBONNET EARTH SWEET CHEWABLES METHYLFOLATE 800 MCG"
93711 19470 "NATURE MADE SUPER B-COMPLEX KEY B VITAMINS + VITAMIN C"
93711 6666666968 "NO PRODUCT INFORMATION AVAILABLE"
93713 17523 "TUMS CALCIUM CARBONATE ANTACID REGULAR STRENGTH 500 GSK"
93715 17568 "EQUATE REGULAR STRENGTH ANTACID CALCIUM CARBONATE 500 MG"
93716 655 "CALCIUM 1000 MG"
93716 8507 "VITAMIN D 2000 IU"
93716 17523 "TUMS CALCIUM CARBONATE ANTACID REGULAR STRENGTH 500 GSK"
93718 9835 "VITAMIN D 5000 IU"
93719 15700 "ONE A DAY FOR HER VITACRAVES TEEN MULTI GUMMIES WITH CALCIUM & VITAMIN D MULTIVITAMIN / MINERAL BAYER"
93721 8507 "VITAMIN D 2000 IU"
93721 19470 "NATURE MADE SUPER B-COMPLEX KEY B VITAMINS + VITAMIN C"
93722 8916 "VITAMIN D 600 IU"
93722 16703 "EQUATE COMPLETE MULTIVITAMIN ADULTS MULTIVITAMIN / MULTIMINERAL COMPLETE WITH 30 NUTRIENTS"
93723 646 "VITAMIN D 1000 IU"
93723 11863 "NATURE MADE FISH OIL 1000 MG 300 MG OMEGA-3"
93723 17603 "SUNDOWN NATURALS WHOLE HERB SAW PALMETTO 450 MG"
93723 19427 "CENTRUM SILVER ADULTS 50+ MULTIVITAMIN / MULTIMINERAL"
93725 14912 "WALGREENS MULTIVITAMIN GUMMIES CHILDREN"
93726 15476 "CENTRUM SILVER WOMEN 50+ MULTIVITAMIN / MULTIMINERAL"
93726 17712 "DEFAULT DHA"
93726 18945 "VIVA NATURALS ULTRA STRENGTH OMEGA-3 FISH OIL FROM WILD, SUSTAINABLY-CAUGHT FISH 2200 MG FISH OIL 1400 MG EPA 480 MG DHA PER SERVING (2 SOFTGELS)"
93726 6666666987 "NO PRODUCT INFORMATION AVAILABLE"
93727 19029 "PURITAN'S PRIDE CHEWABLE ACEROLA C VITAMIN C 100 MG VEGETARIAN VITAMIN"
93727 19037 "PURITAN'S PRIDE ULTRA VITA-MIN MULTIVITAMIN / MULTIMINERAL VM-33"
93728 647 "POTASSIUM 99 MG"
93733 18188 "KROGER CHILDREN'S CHEWABLES COMPLETE 16 NUTRIENTS MULTIVITAMIN / MULTIMINERAL"
93737 12256 "CVS PHARMACY DAILY GUMMIES COMPLETE ADULT MULTIVITAMIN MULTIVITAMIN / MULTIMINERAL"
93740 632 "VITAMIN B-12 (COBALAMIN) 1000 MCG"
93742 603 "MAGNESIUM 250 MG"
93742 632 "VITAMIN B-12 (COBALAMIN) 1000 MCG"
end
[/CODE]

I want to keep only rows that contain any words in this list "“ACIDOPHILUS, ANIMALIS, BACILLUS, BACILLI, BIFIDOBACTERI, BIFIDUM, BOULARDII, BREVE, BREVIS"

[Andrew Musau]

See #3: https://www.statalist.org/forums/for...g-observations
and #2: https://www.statalist.org/forums/for...s-certain-word

The second link contains more delimiters.