mikeo1313
06-05-2010, 05:22 PM
I have an excel for recipes I recently imported into an access database
heres how the nutrition data field looks :
84 Calories; 3g Fat (36.5% calories from fat); 1g Protein; 9g Carbohydrate; 1g Dietary Fiber; trace Cholesterol; 81mg Sodium. Exchanges: 0 Grain(Starch); 1/2 Vegetable; 1/2 Fruit; 1/2 Fat.
I've been tinkering with vba for the last couple weeks but I haven't come across a way that I can parse data in this field and separate calories, fat, protein, carbs, etc etc into separate fields.
any suggestions, I'm stuck. I don't care if the suggestion works for excel or access, I just want the data to be separated so I can perform & categorize further. Thanks : pray2:
heres how the nutrition data field looks :
84 Calories; 3g Fat (36.5% calories from fat); 1g Protein; 9g Carbohydrate; 1g Dietary Fiber; trace Cholesterol; 81mg Sodium. Exchanges: 0 Grain(Starch); 1/2 Vegetable; 1/2 Fruit; 1/2 Fat.
I've been tinkering with vba for the last couple weeks but I haven't come across a way that I can parse data in this field and separate calories, fat, protein, carbs, etc etc into separate fields.
any suggestions, I'm stuck. I don't care if the suggestion works for excel or access, I just want the data to be separated so I can perform & categorize further. Thanks : pray2: