string expression help

[Guest]

I have a field that contains a "Project Name" and a "Project Number" in this
format:

Project Name - A07-0001 (9 "end" characters)
OR
Project Name - A07-0001-01 (11 "end" characters)

What I need is to be able to extract only the "project number" portion from
this field. The problem is that sometimes there are 9 OR 11 "end" characters.

If I use "Right ("[Project]", 9)", it works for the 9 character fields but
would only return "7-0001-01" for the 11 character fields.

And if I use "Right ("[Project]", 11)", it works for the 11 charachter
fields but returns " - A07-0001" for the 9 character fields.

This "Project" field will consistently follow the pattern of "Project Name -
Project Number". Is there an expression that could just return all
characters after the first "-"?

Thanks!
Ember

 

[Guest]

Never mind...I tried a few more searches in this community and found what I
needed. In case anyone cares here is what I found that worked for me.

"Hi,
check this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209045

It shows you sample expressions to do exactly what you need.
HTH
Good luck"