Thanks Olaf, i was originally working with *.docx and *.doc but assumed .txt should still work with the same comobject. happy to use either
Sample code from the source file looks like this, i dont really mind how the output is returned i just want to search for something such as Soy and have things like Soya, Soy Milk returned, understandably i will get random text too - this would purely be for me to get a list of variations of known ingredients for my son that he cant have
Includes a minimum of 8 (But could include nearly all) of the following, both whole and split: Adzuki Beans, Baby Lima Beans, Black Beans, Blackeye Peas, Cranberry Beans, Dark Red Kidney Beans, Garbanzos, Great Northern Bean, Large Lima beans, Light Red Kidney Beans, Navy Beans, Pink Beans, Navy Beans, Small Red Beans, White Kidney Beans, Yellow Beans, Green and Yellow Split Peas, Lentils
Chicken breast & southwest rice: [glazed chicken breast with rib meat - chicken breast with rib meat, water, salt, sodium phosphate, dextrose. glaze: water, modified corn starch, maltodextrin, methylcellulose, xanthan gum, caramel color, citric acid. brown rice - whole grain parboiled brown rice. water. gum blend thickener - water, guar gum, locust bean gum, and xanthan gum. diced tomatoes - vine-ripened tomatoes, tomato juice, less than 2% of: calcium chloride, citric acid. diced onions. diced green peppers. shredded cheddar cheese - pasteurized milk, cheese cultures, salt, enzymes, annatto, vegetable color (if colored), corn starch (anti-caking agent). chicken gravy mix - corn starch, wheat flour, chicken flavors (chicken broth, chicken fat, natural flavors, citric acid), salt, dried whey, dextrose, shiitake extract powder (shiitake extract, yeast extract), torula yeast, garlic powder, refined soybean oil, onion powder, spice, roasted onion flavor (canola oil), and oleoresin turmeric. northwest rub - spices, dehydrated garlic, sea salt, dehydrated onion, natural dehydrated lemon and spice extractive.] black beans and corn - [black beans and corn-black beans, corn, diced red peppers, diced onions, water.]
Soybean oil, sugar, soy sauce (water, wheat, soybeans, salt, sodium benzoate; less than 1/10 of 1% as a preservative), rice wine vinegar, water, toasted sesame oil, ground ginger, sodium benzoate, edta (calcium disodium).
Rolled oats, rolled wheat, agave nectar, brown sugar, whole wheat flour, dark sweet cherries (bing cherries & sunflower oil), natural cherry flavored cranberries, unsweetened coconut, walnuts, applesauce (apples & water), pomegranate juice concentrate, ch
Rolled oats, agave nectar, brown sugar, rolled wheat, whole wheat flour, blueberries, unsweetened coconut, walnuts, applesauce (apples & water), mangosteen juice concentrate, salt, soda, cinnamon, all natural vanilla flavoring, natural walnut flavoring.
Rolled oats, brown sugar, rolled wheat, growth hormone-free butter, whole wheat flour, unsweetened coconut, walnuts, maple syrup, salt, soda, natural maple flavoring.
Rolled oats, brown sugar, rolled wheat, whole wheat flour, unsweetened coconut, walnut, salt, soda, natural vanilla, corn syrup, honey, water, cinnamon,`Preformatted text`
also have the same data in xlsx if its easier to work with
Broccoli.
Pineapple, water, pineapple juice from concentrate, ascorbic acid (vitamin c [to protect color]), citric acid.
Beef broth, contains less than 1% of: salt, maltodextrin, yeast extract, beef flavor (salt, beef extract powder [beef stock, autolyzed yeast extract, salt, flavors]), monosodium glutamate, autolyzed yeast extract, caramel color, disodium inosinate, disodium guanylate.
Chicken broth, contains less than 2% of: salt, chicken fat, dextrose, hydrolyzed soy, corn and wheat gluten proteins, onion powder, modified cornstarch, autolyzed yeast, natural flavor, torula yeast, garlic powder, disodium inosinate, disodium guanylate, soybean oil, thiamin hydrochloride, tartaric acid, gum arabic, monosodium glutamate, oleoresin carrot.
Chicken broth, enriched egg noodles (wheat flour, eggs, egg whites, niacin, ferrous sulfate [iron], thiamin mononitrate, riboflavin, folic acid), chicken meat (cooked chicken meat, water, modified food starch, salt, sodium phosphate), contains less than 2% of: salt, modified food starch, chicken fat, monosodium glutamate, chicken flavor (onion powder, autolyzed yeast extract, salt, chicken broth, modified cornstarch, natural flavor), spice extract, onion powder, beta carotene (for color), garlic powder.
Water, mushrooms, soybean oil, modified food starch, wheat flour, contains less than 2% of: salt, cream, whey, monosodium glutamate, soy protein concentrate, yeast extract, natural flavor, garlic powder, titanium dioxide (color).
Tomato puree (water, tomato paste), high fructose corn syrup, water, wheat flour, contains less than 2% of: salt, modified cornstarch, potassium chloride, sea salt, citric acid, ascorbic acid, natural flavoring.
Water, prepared white beans, bacon (cured with water, salt, sugar, sodium phosphate, sodium erythorbate, sodium nitrite), tomato puree (water, tomato paste), carrots, contains less than 2% of: modified food starch, salt, sugar, wheat flour, onion powder, monosodium glutamate, dried torula yeast, natural smoke flavor, citric acid, vegetable juice concentrate (carrots, celery, onion), natural flavor, beta carotene (for color).
Chicken stock, enriched pasta (semolina [wheat], egg white, niacin, ferrous sulfate [iron], thiamin mononitrate, riboflavin, folic acid), chicken meat (cooked chicken meat, water, modified food starch, salt, sodium phosphate), carrots, contains less than 2% of: salt, modified food starch, chicken fat, celery, monosodium glutamate, flavoring, lactic acid, sugar, beta carotene (for color), onion powder, yeast extract.