AnsweredAssumed Answered

Translate ingredientlists script

Question asked by spaartje on Nov 21, 2012
Latest reply on Nov 21, 2012 by comment

Dear Developers,


I have a filled a database with ingredients in 6 languages.

For example, tomato is translated into Dutch, French, German, Spanish and Italian.


My supplier deliver me an ingredientlists as 1 textfield and it looks like this:


flavour enhancer: (monosodium glutamate, nucleotide seasoning), salt, ricepowder, sugar, flavouring: chicken, egg, spices, curry powder (contains turmeric),sesame oil, hydrolyzed vegetable protein (soy), white dextrin, vitamin B2


All the ingredients can be found in the database but what is the best way to separate the ingedients and compare them with ingredients in the database?

I thought up a plan to separate all the ingredients by searching for all comma's in the textfield but that will not help because there the textfield contains : and ( )


Any help is appreciated


Rgds Marcel