Wow, thank you. Works perfectly.
First time I have asked for help, and I am so glad I did.
Thank you very much.
Peter Thomson
Last Activity: Jan 18 '11, 02:48 PM
Joined: Oct 23 '10
Location:
-
The numbers are on the same line. Example :
05VGML/03SFML/01GFML-DAIRY FREE MEAL/04FPML
or it could be:
5 VGML 3 SFML 1 GFML Dairy Free Meal 4 FPML.
It all depends on the style of the data inputter.
I need to add up the total of all the numbers from each Memo field.
And (only if possible) exclude numbers before certain text, ie. BBML.
Hope this is clear.Leave a comment:
-
How to extract numbers from a memo field and sum them.
I have a memo field with a mixture of numbers and text. I would like to add up all the numeric values to obtain a total. Numbers can be in the format 01 or 1, all numbers are no more than 2 digits, but may not have a space before the text.
No activity results to display
Leave a comment: