function to strip characters

[Kirsti]

Hi,



I have a field containing:

CCC1/1234/1
CCC1/123/12
CCC1/5678/56
CCC1/678/3

I need a way to strip the numbers out between / and /.

There could be either 3 or 4 characters after the first / (these are the ones I want), and there could be 1 or 2 characters after the 2nd /.

I can strip the CCC1/ easily because it is always the same, but having trouble figuring out how to strip the characters after the / on the right.

Any help much appreciated

Kirsti

[pbaldy]

You can use the InStrRev() function to find the position of the last /. That with the Mid() the Len() functions and some creative math should provide your result.

[Kirsti]

Thanks Paul.

Got it working using:

IIf([Field1] Is Null,Null,(Mid([Field2],6,(InStr(6,[Field2],"/"))-6)*1))