If I have someone OCR nutrition labels and manually format them like this:
Serving Size = 14g
Servinds per container = About 20
Amount Per Serving
Calories = 40
Calories from Fat 5
% Daily Value
Total Fat =0.5g=1%
Trans Fat 0g
Cholesterol 0mg 0% 1% :VIZI; 00' mg 3%
Total Carbohydrate llo 4%
Protein 1 g
Vitamin A 8%
Vitamin C 8%
I need some script to write the data from each such unit of text to a relational database in a usable format, the meaning of which should be obvious.
How many calories per gram of fat.
The Bolded items, and probably some others are like Categories. The subitems, before the delimiter, or equal sign ate items, and there are values.
The structure should be therefore, something like Category, Item, Value
There are interesting issues here....qualifiers like <, >, About...., and more.
I need intelligence and some understanding of nutrition. If you are an idiot, please do not respond.
If you don't answer the question, I won't respond.
Did you read all teh way to the end? Good for you. Put all the way as the first line of your response.