return part of a field

M

mbc04

I have a field called OCLC# . From that field I want to extract just
the numbers that come after the letters ocm. If the field does not
contain ocm, then return a 0.

Here are some examples of data that are in this field.
ex. (OCoLC)ocm46621126
ocm13214937
90008576 /AC

The results should be: 46621126
13214937
0
How do I do this?
 
T

Tom Lake

I have a field called OCLC# . From that field I want to extract just
the numbers that come after the letters ocm. If the field does not
contain ocm, then return a 0.

Here are some examples of data that are in this field.
ex. (OCoLC)ocm46621126
ocm13214937
90008576 /AC

The results should be: 46621126
13214937
0
How do I do this?
Click to expand...

IIf(Instr([MyStr], "ocm") > 0, Val(Mid([MyStr], Instr([MyStr], "ocm") + 1), 0)

Tom Lake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parsing a field with right string 5
right string problem 7
extract 3 numbers from a string 0
IIF Statement to return multiple values for a field - JohnW 3
how do I extract pieces of data from a field 2
Query Returning Multiple Results 1
return a specific part of a field 2
Return (display) only part of a field 2

Top