How to take portion of the data from a Memo Field

[wongray]

Hi There,

I like to ask how to take a portion of the data from a memo field.

Example:

"This is a test for a memo field and I like to setup a date 01/10/2012. This is somethig I need to do is to able to filter a certain filed in the memo data and take the first 14 character out into differnt querry field."

The answer that I expect in other querry field is:

date 01/10/2012

Please advice.
Thanks


Ray

[June7]

date 01/10/2012 is 15 characters because of the space. These are not the first characters of the example string.

Will the date always be 10 characters, with placeholder zeros? Will there be only the one date in the string? Will those / characters be the first or only ones in the string? Try:

assume x represents name of the memo field
Mid(x, InStr(Nz(x,""),"/")-7,15)