Hey all! I’m building a nutrition database and am trying to find a way to get it so that people can free type the foods they’ve eaten and they system will automatically do a ‘best guess’ match to assign it to the food. I’ve created a dummy doc to show you what I mean. It would be awesome if anyone…

Hi @Ben , Try with this: [List of ingredients example] .Filter(CurrentValue.Ingredient.Lower() .In( thisRow.[NLP identify].FormulaMap(CurrentValue.Name.Lower() ) ) ) The thisRow.[NLP identify].FormulaMap(CurrentValue.Name.Lower() part could be an additional column (…

Awesome!! Thank you! It seems to be working perfectly!

Sorry @Federico_Stefanato , another question on this if you do have a moment! Do you have any thoughts on a better method of applying substitutions to strings of text? As you’ll see above, I’m attempting to replace things like “one” with “1”, and “tablespoon” with “tsp” and a whole lot more. I’ve t…

Dear @Ben_Swanson , I felt to share this doc about proportional recipes from @Mikael_Mayer Hopeful it will be somehow helpful :thinking:

Quick solution: RegexReplace(RegexReplace(“I ate one tablespoon of sugar”, “\bone\b”, “1”), “\btablespoon\b”, “tbsp”) (Evaluates to “I ate 1 tbsp of sugar”) Use \b in regex to indicate a word boundary, so that you will not accidentally replace someone by some1. However, let’s say you want to rep…

Hi @Ben_Swanson , have you tried RegexpReplace() function? You can also chain it with all the occurrences: [Your String].RegexpReplace("one","1").RegexpReplace("tablespoon","tsp") Edit: Sorry, just posted a message that was ready since a while :slight_smile: I saw @Mikael_Mayer provided basicall…

Thank you all very much!! That works great :smile: Sorry again haha but I think I have one more problem which it would be great to get some help with! Is there a way to change the original query which returns the item to somehow match based on contains? For instance, if the list of ingredients co…

Hi @Ben_Swanson , if you strictly need it, we might find a solution, but I’m asking you if this is the actual way to achieve it… Just from a mere semantic approach In my opinion, ingredients should represent the highest level of generalisation (e.g. why “plain yoghurt” instead of “yoghurt”?) in ord…

Thank you @Federico_Stefanato for the thought and comment on this! The reason that I’m having to work this way around is that I have access to a list of 16,000 different ingredients/meals with the nutrient breakdown already provided (e.g. the exact amount of vitamins for each item), and in that lis…

Match text from one column with list from another table

Ben_Swanson September 3, 2020, 10:18am 11

Just to close this off, I figured out / hacked together a solution using @Ben_Lee’s amazing work here.

Thanks again for your help!

Topic		Replies	Views
Filtering from one table to match another	2	392	March 31, 2022
Replacing multiple words within a string of text using a formula	9	1014	July 5, 2023
LookUp based on RegexMatch?	7	1177	February 23, 2019
Find multiple values (CSV column) in text string	6	1481	May 30, 2022
Search any from list pasted in text control	3	104	August 6, 2024

Match text from one column with list from another table

Related topics