extract data from memo

[Gerrit.B]

I have in a memofield some text and also the dimensions of the package.

Sample:

Product Code: 8542
Carton Size: 52.00x31.00x11.00cm
Specification:


Is it possible te extract the dimensions, so i can calculate the volume of the package.

G.

 

[storm8]

where do you want to store the values?

 

[Gerrit.B]

I just want to calculate the volume of the package.

 

[jackd]

If you're going to do this on a regular basis, then I suggest you get your tables structured properly. Get a product table and identify the attributes that are relevant to your proposed use.
Working with some structure in a memo field is not a long term,high use ,maintainable approach.

You'll have to parse the memo field using functions such as
InStr, Mid etc.