<div>
Awesome, thank you so much!
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
Can someone please help me? I have a long text field which contains an alphanumeric reference which I'm trying to extract in my query and can't seem to get it right.<br />
<br />
The string can appear anywhere within the field and begins with &quot;Ref:MSG&quot; and is followed by 8 numbers. These 8 numbers change for each record and there's usually characters or spaces either side of the string. <br />
<br />
A couple of string examples are...<br />
action the below request:^Note: &nbsp;Ref:MSG24621668&gt;^<br />
CUSTOMER^COMMUNICATIONS RE: Ref:MSG61781623non-applica<wbr />ble<br />
<br />
The result I am looking for would be...<br />
Ref:MSG24621668<br />
Ref:MSG61781623<br />
<br />
If someone could help me with this it would be very much appreciated.<br />
<br />
Thanks<br />
darls15
</div>
</div>


Hello

Can someone please help me? I have a long text field which contains an alphanumeric reference which I'm trying to extract in my query and can't seem to get it right.

The string can appear anywhere within the field and begins with "Ref:MSG" and is followed by 8 numbers. These 8 numbers change for each record and there's usually characters or spaces either side of the string. 

A couple of string examples are...
action the below request:^Note:  Ref:MSG24621668>^
CUSTOMER^COMMUNICATIONS RE: Ref:MSG61781623non-applicable

The result I am looking for would be...
Ref:MSG24621668
Ref:MSG61781623

If someone could help me with this it would be very much appreciated.

Thanks
darls15

Extract an alphanumeric  string from a long text field in a MS Access query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.